Name
ALTER SERVER
Synopsis
ALTER SERVERserver
OPTIONS ({ HOSThost
| DATABASEdatabase
| USERuser
| PASSWORDpassword
| SOCKETsocket
| OWNERowner
| PORTport_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');
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.