mysql>update user set host = ‘%‘ where user = ‘root‘;
mysql>select host, user from user;
2.
mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
mysql>flush privileges;
说明：%是哪个IP地址可以访问这个MYsql服务，可以换成你想要的IP地址！
Host is not allowed to connect to this MySQL server 错误的处理方法
标签：
本文系统来源：http://www.cnblogs.com/liulun/p/4539856.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！