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

[Secret Agent]

Hello there. I am trying to connect to a sql database. I made a small test script to test the connection. I am using the sample code that was given from cpanel.

I keep getting the following warning:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/canoesfo/public_html/test.php on line 10 I cannot connect to the database because: Client does not support authentication protocol requested by server; consider upgrading MySQL client


What should I do? Where do I tweak the security settings for this type of thing?

I saw only a few other threads somewhat similiar and the methods didn't work for me.

/scripts/makecpphp
/scripts/easyapache
/scripts/updatenow
/scripts/mysqlup --force

I have MySQL 4.1.10a-standard

[Blue|Fusion]

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

[Secret Agent]

I already added that and restarted mysql, I'll try deleting / removing the user.

Thank you.

[Octo]

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

[shashank]

such an old thread ?

[Snowman30]

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...

[xcopy]

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

[jamesbond]

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...

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