Hi Dan, Instead of skip-networking, use bind-address in my.cnf:
bind-address=192.168.0.1 I think you can just specify 1 IP like that. So... you either have 1) listening on no IP (skip-networking), 2) listening on 1 IP (bind-address), or 3) listening on all IPs (the default). BTW, I think even with bind-address, you can still connect locally via Unix sockets (or named-pipes on NT), as with skip-networking. Not 100% sure on that though. Hope that helps. Matt ----- Original Message ----- From: "Dan Jones" To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 8:15 PM Subject: network interfaces > I have MySQL running on a Linux box with two network interfaces - one is > a routable IP that connects to my DSL bridge and the other is a > non-routable IP (192.168.1.*) that connects to my internal LAN. I'd > like MySQL to be available on the internal interface but not to be > available on the interface that is open to the Internet. I've tried to > RTFM but have found very little info on configuring the MySQL daemon. > The config file (/etc/mysql/my.cnf under Debian) contains entries to > turn off networking completely (skip-networking) and to configure the > port, but I haven't found anything to configure which interfaces it > uses. Info or pointers to info greatly appreciated. > > (And yes, I realize I can configure iptables to block the port but I'd > like to configure MySQL not to listen on that interface as well.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
