ALTER SERVERserver_name
OPTIONS (option
[,option
] ...)
Alters the server information for 更改
, adjusting any of the options permitted in the server_name
CREATE SERVER
statement. server_name
的服务器信息,调整CREATE SERVER
语句中允许的任何选项。The corresponding fields in the mysql.servers
table are updated accordingly. mysql.servers
表中的相应字段将相应更新。This statement requires the 此语句需要SUPER
privilege.SUPER
权限。
For example, to update the 例如,要更新USER
option:USER
选项,请执行以下操作:
ALTER SERVER s OPTIONS (USER 'sally');
ALTER SERVER
causes an implicit commit. ALTER SERVER
导致隐式提交。See Section 13.3.3, “Statements That Cause an Implicit Commit”.请参阅第13.3.3节,“导致隐式提交的语句”。
无论使用何种日志格式,ALTER SERVER
is not written to the binary log, regardless of the logging format that is in use.ALTER SERVER
都不会写入二进制日志。