navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

client does not support authentication protocol requested by server; consider upgrading MySQL client(客户端不支持服务器请求的身份验证协议;请考虑升级MySQL客户端)

解决过程:

一、进入MySQL的安装bin目录,进入黑窗口

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

二、使用root用户名登录(需要输入密码)

mysql -u root -p

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

 三、插叙用户信息

select host,user,plugin,authentication_string from mysql.user;

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

host为%表示不限制ip   

host为localhost表示本机使用   

plugin非mysql_native_password值 则需要修改密码,并以此协议修改密码

 四、更改用户密码(新密码仍然为root密码)

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

五、刷新权限

flush privileges;

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

 六、再次查询用户信息

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

 七、使用navicat重新连接

navicat连接时:client does not support authentication protocol requested by server; consider upgrading M

 

上一篇:navicat for mysql 链接时报错:1251-Client does not support authentication protocol requested by server


下一篇:认识前端工具链(一)之脚手架