MySQL in a Nutshell, 2nd Edition

Name

ALTER SERVER

Synopsis

ALTER SERVER server
   OPTIONS 
    ({ HOST host
     | DATABASE database
     | USER user
     | PASSWORD password
     | SOCKET socket
     | OWNER owner
     | PORT port_number }, ...)

Use this statement to change the settings for a server created for a FEDERATE storage engine. Servers are created with the CREATE SERVER statement. See the description of that statement later in this chapter for more information on the options. The SUPER privilege is required to be able to use this statement. Here is an example:

ALTER SERVER testing 
OPTIONS(USER 'test_user2');