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;