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