if you dont specify it it will listen to all interfaces, and it is the standard option.
you dont break anything. Claudio 2010/12/7 Machiel Richards <machi...@rdc.co.za> > what will the effect be if we disable this option in the config file by > means of hashing out the option? > > will it break the database or just listen on any device? > > > -----Original Message----- > *From*: Claudio Nanni > <claudio.na...@gmail.com<claudio%20nanni%20%3cclaudio.na...@gmail.com%3e> > > > *To*: Machiel Richards > <machi...@rdc.co.za<machiel%20richards%20%3cmachi...@rdc.co.za%3e> > > > *Cc*: mysql mailing list > <mysql@lists.mysql.com<mysql%20mailing%20list%20%3cmy...@lists.mysql.com%3e> > > > *Subject*: Re: Bind-address use? > *Date*: Tue, 7 Dec 2010 09:22:31 +0100 > > > > Hi, > You may have multiple interfaces and each multiple ips (private or public). > With bind-address you force mysql to listen to a specific ip address > instead of any. In case you have both public and private ips, binding to the > private, for example, prevents from connections from the internet. > Just keep in mind a server may belong to multiple subnets and mysql > normally listens to connections coming from any of em. > Cheers > Claudio > > On Dec 7, 2010 9:16 AM, "Machiel Richards" <machi...@rdc.co.za> wrote: > > Hi All > > > > I am unable to find an answer on what the bind-address in > > mysql-5.1 actually does. > > > > From the config file it says that it provides the same function > > as the previous skip-networking function. > > > > However, let's say I configure the bind-adress value to the IP > > of the machine, will this cause any issues with applications connecting > > to the database from various other machines? > > > > > > My reason for looking into this is because currently we are > > experiencing intermittend connection problems (error 2013) but I have > > not been able to pinpoint the issue and was wondering if this is not > > perhaps the issue. > > > > > > Thank you in advance for all responses > > > > Regards > > Machiel > > -- Claudio
