"Host 'USER-XXXX' is not allowed to connect to this MySQL server"

1.在mysql库中，复制user=root,host=‘localhost’的数据，修改localhost为%
数据库信息：

user    host             ------  -----------------root    %   root    localhost    

2.赋权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;FLUSH   PRIVILEGES;  

3.重启mysql