SHOW CREATE SERVER

MariaDB starting with 11.7

The SHOW CREATE SERVER statement was introduced in MariaDB 11.7.

Syntax

SHOW CREATE SERVER server_name

Description

Shows the CREATE SERVER statement that created the given server definition.

Example

SHOW CREATE SERVER srv1\G
*************************** 1. row ***************************
       Server: srv1
Create Server: CREATE SERVER `srv1` FOREIGN DATA WRAPPER mysql 
  OPTIONS (HOST '172.30.0.58', DATABASE 'db1', USER 'maxscale', PASSWORD 'password');

See Also

• CREATE SERVER

• SHOW

_{This page is licensed: CC BY-SA / Gnu FDL}