最近新装完mysql8.0之后出现一个问题。因为安装时选择了它新的密码验证方式,
导致Navicat for Mysql连接时报1251错误。
1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法如下:管理员方式进入cmd,一定要是管理员方式!cd打开mysql安装路径比如:
之后输入
mysql -h localhost -u root -p
mysql> alter user root@localhost identified by 'password' password expire never;
mysql> alter user root@localhost identified with mysql_native_password by 'password';
mysql> flush privileges;
其中password为新密码。