MySQL 8.0-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. The corresponding fields in the 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写入二进制日志。