MySQL allows remote IP access

By default, the user rights within the MySQL database Mysql,user table in Linux are only allowed to land on localhost. Need to change permissions:

Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' password ' with Grant option; (% means all external machines, if a certain machine is specified, change% to the corresponding machine name; ' Root ' means the user name to be used.

mysql> flush Privileges; (Run as a sentence to take effect, or restart MySQL)

Query OK, 0 rows affected (0.03 sec)

To view the permissions of a user:

Mysql>use MySQL;

Mysql> select Host,user from user;

| % | Root | (surface root can be accessed by external IP)

thanks:http://blog.csdn.net/shunzi19860518/article/details/5057657

MySQL allows remote IP access