Lost Percona XtraDB Root Password

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi,

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

Cheers

Mike

1 Like
2

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.

2 Likes