Warning: mysql_connect(): Client does not support authentication protocol

Add the line old-passwords under [mysqld] in /etc/my.cnf. Restart MySQL, and delete and remake the user for the database.

 

http://dev.mysql.com/doc/mysql/en/old-client.html

 

such an old thread ?

 

It might be an old thread but ive just had it happen to me after doing a cpanel upgrade and apache recompile last night, and no i wasnt coming from some old version of cpanel and ive been runnign mysql 4.1 for months...

 

A solution

Maybe you can use this solution:

1) Execute this SQL code in PHPMyAdmin:

SET PASSWORD FOR root@localhost = OLD_PASSWORD('newpassword')

2) Include in my.cnf this line:

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

Save the changes.

4) Edit the archive "config.inc.php" in /usr/local/cpanel/3party/phpMyAdmin and add the new password in the line

$cfg['Servers'][$i]['password'] = 'newpassword';

5) Restart MySQL

If you still have problems:

6) Go to WHM and click in "MySQL"---->"Change User or Database Password"

7) Search the USER of the DATABASE you want to use and write a new password for it.

8) Restart MySQL

Enjoy

 

Did you recompile apache with the same settings? (system mysql versus php's mysql client?)