# mysql.servers Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.servers` table contains information about servers as used by the [Spider](https://mariadb.com/docs/server/server-usage/storage-engines/spider), [FEDERATED](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines/federated-storage-engine) or [FederatedX](https://mariadb.com/docs/server/server-usage/storage-engines/federatedx-storage-engine), [Connect](https://mariadb.com/docs/server/server-usage/storage-engines/connect) storage engines.

The contents are modified by the [CREATE SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-server), [ALTER SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/alter/alter-server) and [DROP SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/drop/drop-server) statements.

This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/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

```sql
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:
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}