Navicat连接mysql报错1130
问题描述:
1130 - Host XXX is not allowed to connect to this MySQL server
解决方案:
- 进入mysql安装路径,输入如下命令,登录mysql
mysql -uroot -p
- 登录mysql数据库后,输入如下命令
use mysql;
select host from user where user="root";
update user set host="%" where user="root";
flush privileges;
之后,navicat即可成功连接mysql。