Sunday, October 04, 2009

Change the mysql root password on Ubuntu

If you guys/gals are maintaining a site and find yourself needing to change the mysql root password on Ubuntu then this post should help you.

Last night, I forgot the root password for mysql on a VPS that I rent. It took a while to find a really simple way to change it but eventually, I found that all I needed to do to change the mysql root password on Ubuntu was to issue the following command:
dpkg-reconfigure mysql-server-5.0

You can then proceed to type in a new mysql root password and type it in again to confirm it.

Did it work for you? You are welcome to post your comments/questions or better yet, link to this post, blog about it and tell all your friends who might find this post useful.

No comments:

Post a Comment