ERROR 1251:Client does not support authentication

7717060

底版本远程连接高版本mysql报ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client,解决方法。
第一种
mysql>; SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
第二种
mysql>; UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';
mysql>; FLUSH PRIVILEGES;
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u1/40306/showart_2022163.html