Did anyone try to update MySQL client and success when the problem occur "Client does not support authentication protocol requested by server; consider upgrading MySQL client."
I know the solution is:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
in the url: http://dev.mysql.com/doc/mysql/en/old-client.html
But if I want to use the new password hashing type. Do anyone know how to do that?
Thanks.
You need a version of PHP that has the updated client. You didn't post any server info, so I don't know what version you have. I use 5.0.3 and have no problems.