Welcome to weblogs.com.pk Sign in | Join | Help

mySQL :: Client does not support authentication protocol requested by server

If you are using pre 4.1 client (PHP 4.x) you might get an error ''Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL''

 

This happens due to the reason that mySQL 4.1+ has new authentication scheme which pre 4.1 clients dont support. Issueing the following statement reset the password to the old scheme.

 

To solve this, issue the following command in your database.

 

            UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

            FLUSH PRIVILEGES;

Published Saturday, March 26, 2005 7:23 PM by khurram

Comments

No Comments

New Comments to this post are disabled