Client does not support authentication protocol requested by server

  今天遇到一个问题
在zend studio 上客户端遇到
Client does not support authentication protocol requested by server
如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client 是4.1或者更高版本.
解决方案
mysql -u xxx -p
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('xxxxx');
mysql> FLUSH PRIVILEGES;
ok!解决