Additional languages
« 13.1.4 ALTER TABLESPACE Syntax
13.1.6 CREATE DATABASE Syntax »
Section Navigation      [Toggle]

13.1.5. ALTER SERVER Syntax

ALTER SERVER  server_name
OPTIONS (option ...)

Alters the server information for server_name, adjusting the specified options as per the CREATE SERVER command. See Section 13.1.11, “CREATE SERVER Syntax”. The corresponding fields in the mysql.servers table are updated accordingly. This statement requires the SUPER privilege.

For example, to update the USER option: 

ALTER SERVER s OPTIONS (USER 'sally');

ALTER SERVER does not cause an automatic commit.