> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table.md).

# 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](/docs/server/server-usage/storage-engines/spider.md), [FEDERATED](/docs/server/server-usage/storage-engines/legacy-storage-engines/federated-storage-engine.md) or [FederatedX](/docs/server/server-usage/storage-engines/federatedx-storage-engine.md), [Connect](/docs/server/server-usage/storage-engines/connect.md) storage engines.

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

This table uses the [Aria](/docs/server/server-usage/storage-engines/aria.md) 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" %}