标题: ERROR 1251:Client does not support authentication [打印本页] 作者: 7717060 时间: 2009-08-08 22:48 标题: 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;