List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:December 7 2010 8:24am
Subject:Re: Bind-address use?
View as plain text  
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>
To: Machiel Richards <machielr@stripped>
Cc: mysql mailing list <mysql@stripped>
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


Thread
Bind-address use?Machiel Richards7 Dec
  • Re: Bind-address use?Claudio Nanni7 Dec
    • Re: Bind-address use?Machiel Richards7 Dec
      • Re: Bind-address use?Claudio Nanni7 Dec
        • RE: Bind-address use?Gavin Towey7 Dec
RE: Bind-address use?Jan Steinman9 Dec