The Ultimate Guide to High Availability with MariaDB

SHOW CREATE SERVER

MariaDB starting with 11.7

The SHOW CREATE SERVER statement was introduced in MariaDB 11.7.

Contents

  1. Syntax
  2. Description
  3. Example
  4. See Also

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

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.