MySQL 8.4 Release Notes
15.1.8 更改服务器语句
ALTER SERVER server_name
OPTIONS (option [, option] ...)
Alters the server information for
, adjusting any of the options permitted in the server_name
CREATE SERVER
statement. The corresponding fields in the mysql.servers
table are updated accordingly. This statement requires the SUPER
privilege.
For example, to update the USER
option:
ALTER SERVER s OPTIONS (USER 'sally');
ALTER SERVER
causes an implicit commit. See Section 15.3.3, “Statements That Cause an Implicit Commit”.
ALTER SERVER
is not written to the binary log, regardless of the logging format that is in use.