The mysql.servers table stores connection information for remote servers, used by the FEDERATED and Spider storage engines.
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:
This page is licensed: CC BY-SA / Gnu FDL
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
Server_name
char(64)
NO
PRI
Host
char(64)
NO
Db
char(64)
NO
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:System tables should not normally be edited directly. Use the related SQL statements instead.