Recover MySQL root password

Last week I found myself in one of those situations where a machine I setup nearly 2 years ago required some additional MySQL databases created and for the life of me I couldn’t find where I had recorded the MySQL root password.

I figured setting a new one should be possible, however I’ve never had to do it. After about literally one search on Google and a few short clicks later I had found what I needed. I ended up at the following site here.

Process looked easy enough so I scheduled an outage window, since the MySQL server in question was being used for a Confluence Wiki.

Sure enough the process worked fine, I now had set a new MySQL root password and brought the services back online.

I of course immediately added the password into my password safe, so I don’t have to do it ever again.