- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 6.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.3 ALTER SERVER Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER LOGFILE GROUP Syntax
- 12.1.3 ALTER SERVER Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER TABLESPACE Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE INDEX Syntax
- 12.1.8 CREATE LOGFILE GROUP Syntax
- 12.1.9 CREATE SERVER Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TABLESPACE Syntax
- 12.1.12 DROP DATABASE Syntax
- 12.1.13 DROP INDEX Syntax
- 12.1.14 DROP LOGFILE GROUP Syntax
- 12.1.15 DROP SERVER Syntax
- 12.1.16 DROP TABLE Syntax
- 12.1.17 DROP TABLESPACE Syntax
- 12.1.18 RENAME TABLE Syntax
ALTER SERVERserver_nameOPTIONS (option[,option] ...)
Alters the server information for
server_nameCREATE
SERVER command. See Section 12.1.9, “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.
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.