mysqlchange-passwordforgot-passwordpercona-xtradb-cluster

SQL root password lost on XtradbCluster Percona, how to reset?

I have a big problem. I have crash my PC, so I lost the ROOT password to access a Perconna Xtradbcluster Databases.

I have access on the Centos ROOT user on clusters servers. (so not too bad) How can i change or reset the password without crashing all databases ?

Information: 

# mysql --version
mysql  Ver 14.14 Distrib 5.5.41-37.0, for Linux (x86_64) using readline 5.1

# service mysql status
SUCCESS! MySQL (Percona XtraDB Cluster) running (7092)
Solution

  • You should be able to follow that tutorial just fine on only 1 of the PXC nodes. When you issue the 'UPDATE' to change the password, it should replicate immediately to the other nodes. Be sure to restart this node with skip-grant-tables turned OFF after you change the password.