13.1.8 ALTER SERVER Statement语句

ALTER SERVER  server_name
    OPTIONS (option [, option] ...)

Alters the server information for server_name, adjusting any of the options permitted in the 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都不会写入二进制日志。