The address you specify in bind tells MySQL where to listen. 0.0.0.0 is a special address, which means "bind to every available network".
Only client software which is able to open a connection to the server using the same address that is specified in the 'bind' option will be allowed to connect.
Some examples:
If MySQL binds to 127.0.0.1, then only software on the same computer will be able to connect (because 127.0.0.1 is always the local computer).
If MySQL binds to 192.168.0.2 (and the server computer's IP address is 192.168.0.2 and it's on a /24 subnet), then any computers on the same subnet (anything that starts with 192.168.0) will be able to connect.
If MySQL binds to 0.0.0.0, then any computer which is able to reach the server computer over the network will be able to connect.
These are all transport-level connections. Remote computers still need to qualify for application-level, which is to say they will still require the correct login credentials and host parameters from mysql.user.
发布评论
评论（1）
你在bind中指定的地址告诉MySQL在哪里监听。 0.0.0.0 是一个特殊地址，意味着“绑定到每个可用网络”。
仅允许使用“绑定”选项中指定的相同地址打开到服务器的连接的客户端软件进行连接。
一些示例：
同一台计算机上的唯一软件
将能够连接（因为
127.0.0.1 始终是本地计算机）。
192.168.0.2（服务器计算机的IP地址是
192.168.0.2 并且位于 /24 子网中），然后是同一子网中的任何计算机
子网（任何以 192.168.0 开头的子网）都可以连接。
0.0.0.0，然后是任何能够访问服务器计算机的计算机
通过网络就能连接。
这些都是传输级连接。远程计算机仍然需要获得应用程序级别的资格，也就是说它们仍然需要来自
mysql.user的正确登录凭据和主机参数。The address you specify in bind tells MySQL where to listen. 0.0.0.0 is a special address, which means "bind to every available network".
Only client software which is able to open a connection to the server using the same address that is specified in the 'bind' option will be allowed to connect.
Some examples:
only software on the same computer
will be able to connect (because
127.0.0.1 is always the local computer).
192.168.0.2 (and the server computer's IP address is
192.168.0.2 and it's on a /24 subnet), then any computers on the same
subnet (anything that starts with 192.168.0) will be able to connect.
0.0.0.0, then any computer which is able to reach the server computer
over the network will be able to connect.
These are all transport-level connections. Remote computers still need to qualify for application-level, which is to say they will still require the correct login credentials and host parameters from
mysql.user.