Right after a fresh installation of phpMyAdmin, you open the main page with your favorite browser (ie explorer no doubt) and view the contents. Our beloved third party displays just fine, but at the bottom there lies the following warning:
Your PHP MySQL library version 5.0.91 differs from your MySQL server version 5.1.50. This may cause unpredictable behavior.
Nobody likes unpredictable behaviors. Check again... Nope, PHP and MySQL newer versions installed. Where does the warning come from? How to deal with this?
After a fresh install of phpMyAdmin, you can use your browser to login (http://www.yoursite-or-IP.com/phpmyadmin) using the credentials root and empty passwort. Obviously this is a security hole that needs to be fixed asap. Not so obvious, however, is how.
Using your terminal (or Putty in Windows), you can use the following command to change the password for root: