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