mysql4.1以上版本连接时，提示错误：Client?does?not?support?authentication?protocol
shell>?mysql?
Client?does?not?support?authentication?protocol?requested?by?server;?consider?upgrading?MySQL?client?
官方的说法是?
MySQL?4.1?and?up?uses?an?authentication?protocol?based?on?a?password?hashing?algorithm?that?is?incompatible?with?that?used?by?older?clients.?.....?
如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client 是4.1或者更高版本.
方法一：
mysql>?SET?PASSWORD?FOR?
????->?'some_user'@'some_host'?=?OLD_PASSWORD('newpwd');?
mysql>?FLUSH?PRIVILEGES;?
方法二：
mysql>?UPDATE?mysql.user?SET?Password?=?OLD_PASSWORD('newpwd')?
????->?WHERE?Host?=?'some_host'?AND?User?=?'some_user';?
mysql>?FLUSH?PRIVILEGES;?
