Skip to main content

MySQL Bind Address

Timothy J Bruce

There are times when you need MySQL to be able to bind to more than one address. In this particular occasion, I was running Nagios locally on the same system as Drupal, my content management system. For some reason Nagios was trying to connect using the loopback address (127.0.0.1) instead of the server IP Address (192.168.230.131). However, MySQL only allows you to set one bind address (bind-address) in the /etc/my.cnf configuration file. The solution is to allow it to bind to ALL IP Addresses (using bind-address=0.0.0.0) in the MySQL configuration file.