# ALTER SERVER

## Syntax

```sql
ALTER SERVER server_name
    OPTIONS (option [, option] ...)
```

## Description

Alters the server information for *server\_name*, adjusting the specified options as per the [CREATE SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-server) command. The corresponding fields in the [mysql.servers table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table) are updated accordingly. This statement requires the [SUPER](https://mariadb.com/docs/server/reference/account-management-sql-statements/grant#super) privilege or, from [MariaDB 10.5.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.5/10.5.2), the [FEDERATED ADMIN](https://mariadb.com/docs/server/reference/account-management-sql-statements/grant#federated-admin) privilege.

ALTER SERVER is not written to the [binary log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log), irrespective of the [binary log format](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/binary-log-formats) being used. From MariaDB 10.1.13, [Galera](https://app.gitbook.com/o/diTpXxF5WsbHqTReoBsS/s/3VYeeVGUV4AMqrA3zwy7/) replicates the [CREATE SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-server), ALTER SERVER and [DROP SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/drop/drop-server) statements.

## Examples

```sql
ALTER SERVER s OPTIONS (USER 'sally');
```

## See Also

* [CREATE SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/create/create-server)
* [DROP SERVER](https://mariadb.com/docs/server/reference/sql-statements/data-definition/drop/drop-server)
* [Spider Storage Engine](https://mariadb.com/docs/server/server-usage/storage-engines/spider)
* [mysql.servers table](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table)

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

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