MySQL/MariaDB Server: Bind To Multiple IP Address

MySQL/MariaDB Server: Bind To Multiple IP Address

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:

refe‮:ot r‬lautturi.com
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.

Created Time:2017-10-30 10:17:51  Author:lautturi