We have known methods to reset MySQL root password but in this post we’ll see how that works for a Galera Cluster; may it be Percona XtraDB Cluster or MariaDB Galera cluster.
Basically a Galera Cluster is bunch of MySQL nodes working together in synchronous replication. The user credential is common to all (Ideally of-course)! Let’s see how straight forward it is to reset password on a Percona Xtradb Cluster lab.
To reset the root password on a standard MySQL instance you may choose either of init-file or skip-grant-tables way. Read More