服务器连接错误Host ‘XXX’ is not allowed to connect to this MySQL server

本地连接远程服务器的MySQL时被拒绝，提示Host ‘XXX’ is not allowed to connect to this MySQL server

解决方法：

登录远程服务器

#mysql -u root -p

输入密码

grant all PRIVILEGES on *.* to 'root'@'%' identified by 'PASSWORD' WITH GRANT OPTION;

将此数据库的所有操作权限赋值给用PASSWORD密码登录的root用户

PS：遇端口不能访问，服务器上的实例中查看及配置端口规则