Mysql #1251错误解决方法

#1251  -- (Client does not support authentication protocol requested by server; consider upgrading MySQL client )

修改数据库用户密码格式

1）MySQL->SET PASSWORD FOR 'some_user'@'some_host'=OLD_PASSWORD('new_password');

      MySQL->FLUSH PRIVILEGES;

2）MySQL->UPDATE MySQL.user SET Password=OLD_PASSWORD('new_password') WHERE Host='some_host' AND User='some_user';

     MySQL->FLUSH PRIVILEGES;

新设置用户或更改密码后需用flush privileges刷新MySQL的系统权限相关表，否则会出现拒绝访问，还有一种方法，就是重新启动mysql服务器，来使新设置生效。

转载于:https://www.cnblogs.com/makeup1122/p/3016949.html