Lost Percona XtraDB Root Password


I have lost the root password for my Percona XtraDB 8 cluster, is there a way to recover?



1 Like

Shut down one of the nodes, add this to the [mysqld] section of my.cnf: skip-grant-tables, start the node back up. Immediately log in as root without a password and run SET PASSWORD = 'mynewpass', log out, shutdown mysql, remove the skip, start mysql back up.

1 Like