" intermittent connection problems (error 2013)"
Look at SHOW PROCESSLIST; when you're having a connection problem. If you see lots of
"unathenticated user" in the list, then it means you're having DNS problems.
Typically the best way to handle this is to set skip-name-resolve, and using ip addresses
instead of hostnames in your mysql users for authentication.
From: Claudio Nanni [mailto:claudio.nanni@stripped]
Sent: Tuesday, December 07, 2010 1:02 AM
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address use?
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
This message contains confidential information and is intended only for the individual
named. If you are not the named addressee, you are notified that reviewing,
disseminating, disclosing, copying or distributing this e-mail is strictly prohibited.
Please notify the sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore does not accept
liability for any loss or damage caused by viruses or errors or omissions in the contents
of this message, which arise as a result of e-mail transmission. [FriendFinder Networks,
Inc., 220 Humboldt Court, Sunnyvale, CA 94089, USA, FriendFinder.com