What if you want it to listen to two or three interfaces (I mean not all interfaces but on more than one interface). Can one separate the addresses by Commas? Each on a new line???/
Thanks Emery ----- Original Message ----- From: "Matt W" <[EMAIL PROTECTED]> To: "Dan Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 03:42 Subject: Re: network interfaces > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
