To configure a MySQL or MariaDB server to bind to multiple IP addresses, you can edit the bind-address
option in the MySQL configuration file (usually /etc/mysql/my.cnf
or /etc/my.cnf
).
To bind MySQL or MariaDB to multiple IP addresses, you can specify a list of IP addresses separated by commas.
For example, to bind the MySQL or MariaDB server to the IP addresses 192.168.1.100
and 192.168.1.101
, you can set the bind-address
option like this:
bind-address = 192.168.1.100,192.168.1.101
Alternatively, you can use the wildcard 0.0.0.0
to bind the MySQL or MariaDB server to all available IP addresses:
bind-address = 0.0.0.0
After making changes to the MySQL configuration file, you will need to restart the MySQL server for the changes to take effect.