Tell me the easiest way to link mysql to multiple ip addresses?

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 i've only been checking an hour ago You can comment the bind-address in my.cnf.

Note: « 1 hour ago » is now more than 10 years ago.

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 ips then you'll have to use a firewall

For MySql version 8.0.13 and above , you can specify a list of comma-separated IP addresses.

bind-address = 10.0.0.1,10.0.1.1,10.0.2.1

Relevant MySql documentation .

Remember to restart your MySQL instance after changing the config file.