Updating the MySQL Password

12 Updating the MySQL Password

Perform the following procedure to change the MySQL password. Ensure that the following commands are executed only from Activ NO:

Log in as admusr on the source server.
```
login: admusr
Password: <current admin user password>
```
Run the following steps to update password for default user or root user:
1. Run the following command to reset the MySQL default user password:
```
$ /usr/TKLC/appworks/bin/resetMysqlPassword
```
2. You are prompted to provide a password:
```
Enter password: <enter the new password>
Enter Password Again: <re-enter the new password>
```
3. Run the following command to reset the MySQL root password:
```
$ /usr/TKLC/appworks/bin/resetMysqlPassword root
```
4. You are prompted to provide a password:
```
Enter password: <enter the new password>
Enter Password Again: <re-enter the new password>
```

Result: The command copies the new password to each reachable server in the topology, and flushes client password caches.

This update command synchronizes the MySQL password on all reachable servers in the topology. Any servers added to the topology after running the update command are automatically configured to use the new password. No server in the topology should be rebooting while the password is being changed. If any servers were not reachable when this command was executed, run the command again later when those servers are reachable.

Note:

You must run the resetMysqlPassword script only after all the servers in the topology have been upgraded to DSR 8.5 or later.