[KLUG Members] MySQL listening on multiple interfaces

[Jamie McCarthy]

mlueck at lueckdatasystems.com (Michael Lueck) writes:

> OK, Mr. DB2 is messing with MySQL today... how in the world do I
> get this thing to listen on multiple IP addresses? I need
> 127.0.0.1 plus the LAN IP of the server it is on.

You do?  Can't local connections go through the IP assigned on the
LAN also?

> The docs for "bind-address" in the config file do not state a
> format for entering multiple addresses.

If you comment out the bind-address line, mysqld will accept a
connection from any IP number, including localhost.

But be very sure you want to do this, it has very serious security
implications.  Normally you want mysqld to listen either only on
localhost, or only on one interface which connencts to a private
network not directly connected to the internet.

If you have three ways to connect to the machine and you want to
listen on exactly two of them, I'm not sure there's an easy way to
do that.
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie at mccarthy.vg