2.3.3 Setting the MySQL Cluster Manager Agent User Name and Password

Normally it is not necessary to alter the user name or password used by the user agent to administer mysqld processes. However, if you should wish to do so, you can change either or both of these, using the procedure outlined here:

  1. Stop all agents. (You can use stop agents for this purpose.)

  2. 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 its value; set a new administrative user account name by uncommenting the line containing manager-username= and setting its value to the new user name. See Section 3.1, “mcmd, the MySQL Cluster Manager Agent”, for more information about these options.

  3. For each mysqld do the following:

    1. Log in (using the mysql client) as the MySQL root user

    2. 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'@'' TO 'newuser'@'';

      If you are changing the user name for the first time, use mcmd for olduser. In addition, you should use for the host name (and not localhost).

    3. Execute the following statement, where newuser is the new user name, and newpass is the new password:

      SET PASSWORD FOR 'newuser'@'' = 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. Use for the host name (and not localhost).

    4. Issue a FLUSH PRIVILEGES statement.

  4. Restart the agents. All agents should now be using the new password for the mcmd accounts on the MySQL servers (mysqld processes).