SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[Fernando Cabal]

Just in case you need the syntax to reset the user password to the old format in order to avoid the missleading "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client" error message whe your php code tries to connect to a database and the password for the user was stored using the new 4.1 password format and you have not configured the /etc/php.ini properly


mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


Fernando
http://www.interteldepot.com
Cheap Domains & Hosting solutions