To change the MySQL password:
- Verify that HA and MySQL servers are master.
- Log into the CMP GUI.
- Clear any critical alarms and MySQL alarms.
MySQL related alarms are:
- 70020—QP Master database is outdated
- 70021—QP slave database is unconnected to the master
- 70022—QP Slave database failed to synchronize
- 70023—QP Slave database lagging the master
- 70024—QP Slave database is prevented from synchronizing with the master
- 70025—QP Slave database is a different version than the master
- Set any secondary and tertiary servers (server-b or server-c) to forced standby.
- Locate the master MySQL node.
The master MySQL node is the active MA or CMP in primary site for. There are two ways to find the master MySQl node:
- Login into the CMP GUI, and find the active server by selecting .
- Use the wbAccess mysqlState command in the CLI.
- Using the CLI , enter manageMySQL ModifyMySQLRootPWD to modify the MySQL password.
The password is 1 to 32 characters in length.
Because of MySQL cluster replication, this change is replicated to all slave MySQL servers, then the password in the database of all the MySQL servers is changed synchronously.
- Remove the forced standby from all secondary and tertiary servers (server-b or server-c).
Your MySQL password is changed.