MySQL - ALTER SERVER Statement

MySQL ALTER SERVER Statement

If you need to use either of the Spider, FEDERATED or FederatedX storage engines. You need to create a server.

You can change the server information i.e. the options permitted while creating the server, using the ALTER SERVER statement.

Syntax

Following is the syntax of the ALTER SERVER statement −

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

Example

Assume we have created a server named myserver using the CREATE SERVER statement as shown below −

CREATE SERVER myserver FOREIGN DATA WRAPPER mysql OPTIONS 
(USER 'Remote', HOST 'localhost', DATABASE 'federated');

If you list out the servers in mysql using the SELECT statement you can observe the above created server in it −

SELECT * FROM mysql.servers;

Output

The above query produces the following output −

*********** 1. row ***********
Server_name: myserver
       Host: localhost
         Db: federated
   Username: Remote
   Password:
       Port: 0
     Socket:
    Wrapper: mysql
      Owner:
1 row in set (0.00 sec)

Following query alters the above created server −

ALTER SERVER myserver OPTIONS (USER 'test');

Verification

If you verify the list of servers again you can observe the changed user name as shown below −

SELECT * FROM mysql.servers; 
MySQL ALTER SERVER Statement;

Following is the output of the above query −

*********** 1. row ***********
Server_name: myserver
       Host: localhost
         Db: federated
   Username: test
   Password:
       Port: 0
     Socket:
    Wrapper: mysql
      Owner: