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.
configurationiplinuxMySQL
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.
Best Answer
No, there isn't (I just checked 1 hour ago). You can comment the bind-address in my.cnf:
If you want only 2 IPs, you will then have to use a firewall.
For MySql version 8.0.13 and above, you can specify a list of comma-separated IP addresses.
Relevant MySql documentation.
Remember to restart your MySQL instance after changing the config file.