如何设置mysql可以通过内网访问？

Question

两台阿里云ECS服务器都有内网IP（不同），一台A服务器用作mysql数据库+少量web访问，另一台B
纯粹web访问。
目前A服务器开启外网访问，B服务器可以通过公网IP访问到数据库。
需求是如何配制A服务器的mysql，可以让B服务器通过内网ip去访问它?

Answer 1

The bind-address in my.cnf is configured as A's intranet ip
mysql corresponding user settings allow access to B's intranet ip
Configure A's firewall rules (don't worry if the firewall is not enabled by default)

Answer 2

When generating a user, limit the user's IP or MYSQL only allows access to the specified IP.
If the user is generated, username@host must be configured when generating the user.
If you configure MYSQL to only allow specified IP access, find the
bind-address line in the mysql configuration file and add address access according to the original example

Answer 3

http://blog.csdn.net/duck_arrow/article/...