I found this tutorial : https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/
I have 3 nodes on the percona XtraDBCluster.
- Does i need to stop FIRST the 2 others nodes before change the root password on the last one ?
My think is, if i change the password on one node WITHOUT stop the 2 others nodes the new password will be crushed, when i will restart the mysql service.
2) Other think if i stop 2 nodes first, and change the password on the last one.
Then restart the mysql after the root password changed, and at end the end start the 2 nodes, the new password wil be distributed on the 2 others nodes ?
I don’t know if i am clear.