设立MYSQL允许用IP访问

设置MYSQL允许用IP访问

mysql>use mysql;
mysql>update user set host = '%'  where user ='root'; //or any other user need to remote connect.
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
mysql>quit