解决方法:
1.更新 user表的 host 为 '%'
update user set host ='%' where user =‘root’;
2.修改 密码规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; # 修改密码
flush privileges;
解决方法:
1.更新 user表的 host 为 '%'
update user set host ='%' where user =‘root’;
2.修改 密码规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; # 修改密码
flush privileges;
本文标题:Navicat 连接 MySQL 报错 Authenticat
本文链接:https://www.haomeiwen.com/subject/ubosbltx.html
网友评论