linux - How to bind MySQL server to more than one IP address?

Saturday, March 4, 2017

Is there a secret way to bind MySQL to more than one IP address?

As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.

Answer

No, there isn't (I just checked 1 hour ago). You can comment the bind-address in my.cnf:

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 IPs, you will then have to use a firewall.

Blog