Changing MySQL root password (using phpMyAdmin, Ubuntu linux)

If you have phpMyAdmin installed, it can be used to change the MySQL root password. (If you don’t have phpMyAdmin installed, there are installation instructions in this post.)

1. Log in to phpMyAdmin. (If you have phpMyAdmin set up as described in this post, log in to phpMyAdmin by opening a web browser like Firefox and entering http://localhost/phpmyadmin/ as the URL.)
2. Click on the ‘Privileges’ tab to view a list of all Users.
3. Click the little pencil icon in the rightmost column of each ‘root’ account.
4. Enter a password in appropriate field of the newly-loaded page.