Wednesday, June 21, 2006

"Could not connect to mySQL server: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

"Could not connect to mySQL server: Client does not support authentication protocol request consider upgrading MySQL client"

mysql
update mysql.user set password=OLD_PASSWORD('pass')
where User='user1';
Query OK, 0 rows affected (0.06 sec)Rows matched: 1 Changed: 0 Warnings: 0

This will solve this problem..
Detail about cause of this problem :
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html