1130-host '192.168.1.4' is not allowed to connect to this MySql server

1130-host '192.168.1.4' is not allowed to connect to this MySql server

解决方法：
 
如果想允许用户root使用密码123456从任何主机连接到mysql服务器

mysql>grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option; 
mysql>flush privileges;

如果想允许用户root使用密码123456从ip为192.168.1.6的主机连接到mysql服务器

mysql>grant all privileges on *.* to 'root'@'192.168.1.6' identified by '123456' with grant

option; 
mysql>flush privileges; 
 

如果想允许用户root使用密码123456从ip为192.168.1.6的主机连接到mysql服务器的dk数据库

mysql>grant all privileges on dk.* to 'root'@'%' identified by '123456' with grant option; 
mysql>flush privileges; 

本文转自linux博客51CTO博客，原文链接http://blog.51cto.com/yangzhiming/836894如需转载请自行联系原作者

yangzhimingg