ALTER SERVERserver_name
OPTIONS (option
[,option
] ...)
Alters the server information for
,
adjusting the specified options as per the
server_name
CREATE SERVER
command. See
Section 12.1.16, “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.
ALTER SERVER
was added in MySQL
5.1.15.
User Comments
Add your own comment.