MySQL Cluster Manager 8.0 User Manual  /  ...  /  Setting the MySQL Cluster Manager Agent User Name and Password

3.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 agent configuration file. Set a new password by uncommenting the line containing mcmd_password= and adding the new password as its value; set a new administrative user account name by uncommenting the line containing mcmd_user= and setting the value to the new user name. See Section 4.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 the agent configuration file:

      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. In addition, you should use 127.0.0.1 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'@'127.0.0.1' = PASSWORD('newpass');

      Use mcmd for the user name if you have not changed it—that is, if mcmd-user has been left unset in the agent configuration file. Use 127.0.0.1 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).