mysql.servers Table

The mysql.servers table stores connection information for remote servers, used by the FEDERATED and Spider storage engines.

System tables should not normally be edited directly. Use the related SQL statements instead.

The mysql.servers table contains information about servers as used by the Spider, FEDERATED or FederatedX, Connect storage engines.

The contents are modified by the CREATE SERVER, ALTER SERVER and DROP SERVER statements.

This table uses the Aria storage engine.

The mysql.servers table contains the following fields:

Field	Type	Null	Key	Default	Description
Server_name	char(64)	NO	PRI
Host	char(64)	NO
Db	char(64)	NO
Username	char(80)	NO
Password	char(64)	NO
Port	int(4)	NO		0
Socket	char(64)	NO
Wrapper	char(64)	NO			mysql or mariadb
Owner	char(64)	NO

Example

SELECT * FROM mysql.servers\G
*************************** 1. row ***************************
Server_name: s
       Host: 192.168.1.106
         Db: test
   Username: Remote
   Password: 
       Port: 0
     Socket: 
    Wrapper: mariadb
      Owner:

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