MySQL :: MySQL 8.4 Reference Manual :: 15.1.8 ALTER SERVER Statement (original) (raw)

15.1.8 ALTER SERVER Statement

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

Alters the server information for_`servername`_, adjusting any of the options permitted in theCREATE SERVER statement. The corresponding fields in the mysql.servers table are updated accordingly. This statement requires theSUPER privilege.

For example, to update the USER option:

ALTER SERVER s OPTIONS (USER 'sally');

ALTER SERVER causes an implicit commit. SeeSection 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.