diff options
Diffstat (limited to 'mysql-test/main/ps_missed_cmds_bin_prot.result')
| -rw-r--r-- | mysql-test/main/ps_missed_cmds_bin_prot.result | 32 |
1 files changed, 19 insertions, 13 deletions
diff --git a/mysql-test/main/ps_missed_cmds_bin_prot.result b/mysql-test/main/ps_missed_cmds_bin_prot.result index a56371565a6..6ff37651e4d 100644 --- a/mysql-test/main/ps_missed_cmds_bin_prot.result +++ b/mysql-test/main/ps_missed_cmds_bin_prot.result @@ -107,25 +107,31 @@ DROP TABLE t1; HELP `ALTER SERVER`; name description example ALTER SERVER Syntax ------- +------ + ALTER SERVER server_name - OPTIONS (option [, option] ...) - + OPTIONS (option [, option] ...) + Description ------------ -Alters the server information for server_name, adjusting the -specified -options as per the CREATE SERVER command. The corresponding -fields in the mysql.servers table are updated accordingly. -This statement requires the SUPER privilege. - +----------- + +Alters the server information for server_name, adjusting the specified options +as per the CREATE SERVER command. The corresponding fields in the +mysql.servers table are updated accordingly. This statement requires the SUPER +privilege or, from MariaDB 10.5.2, the FEDERATED ADMIN privilege. + +ALTER SERVER is not written to the binary log, irrespective of the binary log +format being used. From MariaDB 10.1.13, Galera replicates the CREATE SERVER, +ALTER SERVER and DROP SERVER statements. + Examples --------- +-------- + ALTER SERVER s OPTIONS (USER 'sally'); - -URL: https://mariadb.com/kb/en/library/alter-server/ + +URL: mariadb.com/kb/en/alter-server/ # Test case 11: Check that the statements CREATE/ALTER/DROP PROCEDURE # are supported by prepared statements CREATE PROCEDURE p1() SET @a=1; |