ALTER SERVERserver_nameOPTIONS (option[,option] ...)
Alters the server information for 更改, adjusting any of the options permitted in the server_nameCREATE 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都不会写入二进制日志。