Mysql数据库在安装时为了安全，默认是不开放外网访问，只允许127.0.0.1本地访问。下面介绍如何在服务器上配置mysql数据库允许外网访问。

1.登录数据库
mysql -u root –p

输入密码

进入mysql模式：
mysql> use mysql;

2.查询host
mysql> select user,host from user;

+------+-----------------------+

| user | host                  |

+------+-----------------------+

| root | 127.0.0.1             |

| root | localhost             |

| root | localhost.localdomain |

+------+-----------------------+

7 rows in set (0.00 sec)

3.创建host
如果没有"%"这个host值,就执行下面这两句:
mysql> update user set host='%' where user=' root ';
mysql> flush privileges;

再查询host

mysql> select user,host from user;

+------+-----------------------+

| user | host                  |

+------+-----------------------+

| root | %                     |

| root | 127.0.0.1             |

| root | localhost             |

| root | localhost.localdomain |

+------+-----------------------+

7 rows in set (0.00 sec)

4.授权用户
任意外网主机以用户名root和密码passwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd' WITHGRANT OPTION;
mysql> flush privileges;

配置指定的IP访问mysql服务器

IP为222.186.73.28的外网主机以用户root和密码pwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'222.186.73.28' IDENTIFIED BY'passwd' WITH GRANT OPTION; 
mysql> flush privileges;

配置完以上步骤就可以通过外网主机连接mysql数据库，并维护您的数据了。如按以上方法设置后，还是问题可以联系我们QQ：97156534 帮您解决问题！