Saturday, March 4, 2017

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




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.


No comments:

Post a Comment