Did anyone try to update MySQL client when "Client does not support authenticati

[cpthk]

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.

[kegobeer]

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.