All pages
Powered by GitBook
1 of 1

Loading...

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 are updated accordingly. This statement requires the privilege or, from , the privilege.

ALTER SERVER is not written to the , irrespective of the being used. From MariaDB 10.1.13, replicates the , ALTER SERVER and statements.

Examples

See Also

This page is licensed: GPLv2, originally from

mysql.servers table
SUPER
FEDERATED ADMIN
binary log
binary log format
CREATE SERVER
DROP SERVER
CREATE SERVER
DROP SERVER
Spider Storage Engine
mysql.servers table
fill_help_tables.sql
Galera
ALTER SERVER s OPTIONS (USER 'sally');
MariaDB 10.5.2