You can’t bind to more than one IP address, but you can bind to all available IP addresses instead. If so, just use
0.0.0.0 for a binding address in your MySQL configuration file (e.g. /etc/mysql/my.cnf) as follows:
bind-address = 0.0.0.0
If the address is 0.0.0.0, the server accepts TCP/IP connections on all server host IPv4 interfaces.
Furthermore if the address is
::, the server accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces. Use this address to permit both IPv4 and IPv6 connections on all server interfaces.
Or you can simply comment out
bind-address= altogether, so it will bind to all addresses. But make sure that you don’t have
skip-networking enabled in your my.cnf if you want to allow remote connections as well (Read more: MySQL: Allow both remote AND local connections).
After changing the binding address, don’t forget to restart your MySQL server by:
sudo service mysql restart
Eventually you can consider to run multiple instances of MySQL on a single machine (different ports) with Master/Slave replication. Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves).