Navicat 连接 MySQL 报错 Authenticat
2021-08-14 本文已影响0人
米奇小林
解决方法:
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;