if you dont specify it it will listen to all interfaces,
and it is the standard option.
you dont break anything.
2010/12/7 Machiel Richards <machielr@stripped>
> 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
> *To*: Machiel Richards
> *Cc*: mysql mailing list
> *Subject*: Re: Bind-address use?
> *Date*: Tue, 7 Dec 2010 09:22:31 +0100
> 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.
> On Dec 7, 2010 9:16 AM, "Machiel Richards" <machielr@stripped> 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