Navicat连接mysql报错

1、连接报错

1130 - Host XXX is not allowed to connect to this MySQL server

2.在安装Mysql数据库的主机上登录root用户

3. select host from user where user=‘root’;

4.执行update user set host = ‘%’ where user ='root’将Host设置为通配符%。

5.执行flush privilegs使配置立即生效。