MySQL bind-address
--bind-address=IP
Command-Line Format --bind-address=name
Config-File Format bind-address
Permitted Values
Type string
Default 0.0.0.0
Range 0.0.0.0-255.255.255.255
The IP address to bind to. Only one address can be selected. If this option is specified multiple times, the last address given is used.
If no address or 0.0.0.0 is specified, the server listens on all interfaces.
mysqlが した 、つまりローカルlocalhostの 、 は で127.0.0.1を してnetstat-antを ることができて、ポートlistenの 、0.0.0.0つまりALLで、
You can bind only to network interfaces available on the machine where MySQL is running. Assume your PC has 3 network interfaces: - 127.0.0.1 (local host or local loop) - 192.168.0.50 (network card/cable) - 192.168.0.70 (network card/wireless) Normally, the MySQL server will listen on all three interfaces. This is the default, but if it makes you happy :-) you could set it explicitly, with --bind-address='0.0.0.0'. If you want MySQL to listen only on the cable interface you would set --bind-address='192.168.0.50'.