
正文
navicat连接mysql出现Client does not support authentication protocol requested by server解决方案
提示:扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
FLUSH PRIVILEGES;root是用户名
localhost是ip地址127.0.0.1都是特指本机,%表示任何IP都可访问
mysql_native_password是旧的密码验证机制,831015是密码,最后别忘了分号;
https://blog.csdn.net/fenglailea/article/details/78528766
https://blog.csdn.net/boling_cavalry/article/details/78934391
https://blog.51cto.com/bigboss/2129477








