问题:navicat出现远程连接数据库出现的错误代码是1130,ERROR 1130: Host X.X.X.X is not allowed to connect to this MySQL server
解决办法:在服务器登入mysql后,更改mysql数据库里的user表里的host项,从localhost改称%
命令:
use mysql;
grant all privileges on *.* to 'root'@'%' identified BY '密码' with grant option;
flush privileges;
注意防火墙开启
暂时没有遇到其他问题;