Host '192.168.1.110' is not allowed to connect to this MySQL server

q528

$ mysql -h 192.168.1.8 -u root -p
Enter password:
ERROR 1130: Host '192.168.1.110' is not allowed to connect to this MySQL server
　　

$ telnet 192.168.1.110 3306
host 192.168.1.4 is not allowed to connect to this mysql server
　　
　　mysql 默认安装是不允许远程登陆,只能通过localhost登录,因此你需要为你访问主机授权. 
　　一. 主机授权
　　1.1 为主机192.168.1.110授权

$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@'192.168.1.110' IDENTIFIED BY 'mypass';
mysql> FLUSH PRIVILEGES;
　　
　　1.2 为所有主机授权

GRANT ALL ON *.* to 'root'@'%' IDENTIFIED BY 'scada';
flush privileges;
　　
　　二. 修改用户密码

update user set password=PASSWORD('mypass') where user='root';
flush privileges;