Normally it is not necessary to alter the user name or password used by the user agent to administer mysqld processes. Howver, if you should wish to do so, you can change either or both of these, using the procedure outlined here:
Stop all agents. (You can use stop
agents for this purpose.)
Update the etc/mcmd.ini agent
configuration file. Set a new password by uncommenting the
line containing manager-password = and
adding the new password as this value; set a new
administrative user account name by uncommenting the line
containing manager-user = and setting
this to the new user name. See
Section 2.4, “MySQL Cluster Manager Configuration File”, for more
information about these options.
For each mysqld do the following:
Log in (using the mysql client) as
the MySQL root user
If you are changing the user name, do this first,
using the following statement, where
olduser is the current user
name and newuser is the new
manager-user that you set
previously in etc/mcmd.ini:
RENAME USER'olduser'@'127.0.0.1' TO 'newuser'@'127.0.0.1';
If you are changing the user name for the first time,
use mcmd for
olduser. (Prior to MySQL Cluster Manager
1.2.4, if you are doing this for the first time, use
admin for
olduser. See Bug
#16476206.) In addition, you should use
127.0.0.1 for the host name (and
not localhost).
Execute the following statement, where
newuser is the new user
name, and newpass is the
new password:
SET PASSWORDFOR 'newuser'@'127.0.0.1' = PASSWORD('newpass');
Use mcmd for the user name if you
have not changed it—that is, if
manager-user has been left unset in
mcmd.ini. (Prior to MySQL Cluster Manager 1.2.4,
if you are doing this for the first time, use
admin for
olduser.) Use
127.0.0.1 for the host name (and
not localhost).
Issue a FLUSH
PRIVILEGES statement.
Restart the agents. All agents should now be using the new
password for the mcmd accounts on the
MySQL servers (mysqld processes).
© 2013, Oracle Corporation and/or its affiliates