MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.6 ALTER SERVER Syntax

Section Navigation [Toggle]

12.1 Data Definition Statements
12.1.1 ALTER DATABASE Syntax
12.1.2 ALTER EVENT Syntax
12.1.3 ALTER LOGFILE GROUP Syntax
12.1.4 ALTER FUNCTION Syntax
12.1.5 ALTER PROCEDURE Syntax
12.1.6 ALTER SERVER Syntax
12.1.7 ALTER TABLE Syntax
12.1.8 ALTER TABLESPACE Syntax
12.1.9 ALTER VIEW Syntax
12.1.10 CREATE DATABASE Syntax
12.1.11 CREATE EVENT Syntax
12.1.12 CREATE FUNCTION Syntax
12.1.13 CREATE INDEX Syntax
12.1.14 CREATE LOGFILE GROUP Syntax
12.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
12.1.16 CREATE SERVER Syntax
12.1.17 CREATE TABLE Syntax
12.1.18 CREATE TABLESPACE Syntax
12.1.19 CREATE TRIGGER Syntax
12.1.20 CREATE VIEW Syntax
12.1.21 DROP DATABASE Syntax
12.1.22 DROP EVENT Syntax
12.1.23 DROP FUNCTION Syntax
12.1.24 DROP INDEX Syntax
12.1.25 DROP LOGFILE GROUP Syntax
12.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
12.1.27 DROP SERVER Syntax
12.1.28 DROP TABLE Syntax
12.1.29 DROP TABLESPACE Syntax
12.1.30 DROP TRIGGER Syntax
12.1.31 DROP VIEW Syntax
12.1.32 RENAME DATABASE Syntax
12.1.33 RENAME TABLE Syntax
12.1.34 TRUNCATE TABLE Syntax

12.1.6. `ALTER SERVER` Syntax

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

Alters the server information for server_name, adjusting any of the options allowed in the CREATE SERVER statement. See Section 12.1.16, “CREATE SERVER Syntax”. 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 does not cause an automatic commit.

ALTER SERVER was added in MySQL 5.1.15.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

12.1.6. ALTER SERVER Syntax

User Comments

12.1.6. `ALTER SERVER` Syntax