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:
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.