Mysql 远程访问出现 “SQL Error (1130): Host ‘X.X.X.X’ is not allowed to connect to this MySQL server“
1.命令登录mysql管理
2.进入mysql数据库
3.查看user表(select host,user from user; )
4.修改 user表( update user set host=’%’ where user=‘root’; )
修改后结果如下:
5.重启mysql服务