.. title: MySQL Bind Address
.. slug: mysql_bind_address
.. date: 2009/08/17 18:12
.. tags: mysql, sql, database, network
.. link: 
.. description: My notes from my presentation on AIDE (Advanced Intrusion Dection Environment)
.. type: text

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.