Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.