I found myself toying with one of my test servers the other nite and realized that I didn’t know what the root password was for my MySQL database. After a quick bit of Google searching I found a very easy solution. Granted this may be limited to recent releases of Ubuntu (tested on Ubuntu 7.10), but other solutions did not work for me.
Resetting the Password
To reset the MySQL root password on Ubuntu we can simply reconfigure the installed package, which prompts for the root user password setting at installation.
sudo dpkg-reconfigure mysql-server-5.0
This should display a dialog box asking for a new root user password. Enter a new password and it’s reset. Can’t be much simpler than that.