远程MySQL报错：is not allowed to connect to this MySQL server
原因：远程MySQL设置不允许远程：
解决：
一、登录mysql :mysql -u root -p
二、然后使用命令--
允许指定IP连接：GRANT ALL PRIVILEGES ON *.* TO 'root'@'允许连接的ip地址' IDENTIFIED BY '允许连接的密码' WITH GRANT OPTION;
刷新命令：flush privileges;
或者允许所有连接：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '允许连接的密码' WITH GRANT OPTION;
刷新命令：flush privileges;