Navicat出错:1130-host.isnotallowedtoconnecttothisMySqlserver,MySQL的解决办法
具体原理是localhost改成%。
进入mysql -p 附带 5.7安装完毕之后给的默认密码
mysql -uroot -p
输入一下命令
use mysql;
update user set host ='%'where user ='root' and host ='localhost';
flush privileges;
Navicat出错:1130-host.isnotallowedtoconnecttothisMySqlserver,MySQL的解决办法
具体原理是localhost改成%。
进入mysql -p 附带 5.7安装完毕之后给的默认密码
mysql -uroot -p
输入一下命令
use mysql;
update user set host ='%'where user ='root' and host ='localhost';
flush privileges;