ALTER SERVER

Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.

Syntax

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

Description

Alters the server information for server_name, adjusting the specified options as per the CREATE SERVER command. The corresponding fields in the mysql.servers table are updated accordingly. This statement requires the SUPER privilege or, from MariaDB 10.5.2, the FEDERATED ADMIN privilege.

ALTER SERVER is not written to the binary log, irrespective of the binary log format being used. From MariaDB 10.1.13, Galera replicates the CREATE SERVER, ALTER SERVER and DROP SERVER statements.

Examples

ALTER SERVER s OPTIONS (USER 'sally');

See Also

• CREATE SERVER

• DROP SERVER

• Spider Storage Engine

• mysql.servers table

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}