[KLUG Members] MySQL listening on multiple interfaces

[Jamie McCarthy]

mlueck at lueckdatasystems.com (Michael Lueck) writes:

> Only catch is that each of those other programs local on the box
> must be adjusted from their default of 127.0.0.1 to the IP of the
> box AND then maintain them when the box IP changes... whereas
> 127.0.0.1 always works.

Actually, I just remembered... last I heard, MySQL short-circuits
connections to 'localhost' through the unix domain socket.  So the
machine doesn't actually need to listen on the TCP port on 127.0.0.1
anyway.  Try setting up your local clients to connect to 'localhost'
and I bet it works even if networking is turned off or you are only
listening on the ethernet interface.

As a bonus, connections through the unix socket go a few percent
faster, I think (though that's rarely significant compared to the
server performance :)
-- 
  Jamie McCarthy
 http://mccarthy.vg/
  jamie at mccarthy.vg