From: Claudio Nanni
Date: December 7 2010 9:01am
Subject: Re: Bind-address use?
List-Archive: http://lists.mysql.com/mysql/223748
Message-Id: <AANLkTikdD9y8t6vgoCE8q7xotv-PZmhYh8OaM364pnm2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf303f64be25c1340496ce420c

--20cf303f64be25c1340496ce420c
Content-Type: text/plain; charset=ISO-8859-1

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 <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 <claudio.nanni@stripped<Claudio%20Nanni%20%3cclaudio.nanni@stripped%3e>
> >
> *To*: Machiel Richards <machielr@stripped<Machiel%20Richards%20%3cmachielr@stripped%3e>
> >
> *Cc*: mysql mailing list <mysql@stripped<mysql%20mailing%20list%20%3cmysql@stripped%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" <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
>
>


-- 
Claudio

--20cf303f64be25c1340496ce420c--