ERROR 1251:Client does not support authentication

底版本远程连接高版本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;