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?
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
You may have multiple interfaces and each multiple ips (private or
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
> 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