Cannot connect to mysql after upgrade via cpanel

Question

Have cpanel, tried to upgrade from mysql 5.0.98 to 5.1.x using easyapache. After that happen my site went down and cpu went sky high with a ton of queries. Using php 4.4.9. Went ahead and downgraded mysql back to original version. Mysql back to old version and I can connect via phpmyadmin via whm but now my php scripts cant connect to mysql. Getting error:

Error establishing mySQL database connection. Correct user/password? Correct hostname? Database server running?

Any ideas?

Answer 1

The fix was to reset the password with old_password function in mysql:

SET PASSWORD FOR 'mysqlaccount@localhost' = OLD_PASSWORD('somepassword');

Afterwards our scripts could connect to mysql.