Usually this is caused by DNS-based authentication, where the
reverse-DNS lookups are hanging for one reason or another.
If you can, switch to IP-based authentication and use --skip-name-resolve.
/ Carsten
On 05.01.2011 08:26, Yogesh Kore wrote:
Hi,
What is unauthenticated user seen in mysql
In news:[EMAIL PROTECTED],
Jerome Macaranas <[EMAIL PROTECTED]> wrote:
> Would it be possible to prevent reverse lookup? Im using the latest
> GA version..
Please read the manual section on how MySQL uses DNS.
Maciek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Would it be possible to prevent reverse lookup? Im using the latest GA
version..
thanks,
On Wednesday 21 February 2007 23:12, Nils Meyer wrote:
> Hi JM,
>
> JM wrote:
> > i got this results from "show processlist"
> >
> > | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect
Hi JM,
JM wrote:
i got this results from "show processlist"
| 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL |
login | |
| 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL |
login | |
That's jus
"http://www.xamo.com:61519>" is not actually part of the
output from SHOW PROCESSLIST correct?
Have you tried starting MySQL with --skip-name-resolve ? If this is
the issue I'm thinking it is, would you be able to run tcpdump
through grep for DNS traffic and see if anything is going on. And
how w
Well, this has been fixed, for your info, it was a problem from our
DNS's with the reverse name process.
Greets.
Javier Tacon
-Mensaje original-
De: Javier Tacón [mailto:[EMAIL PROTECTED]
Enviado el: martes, 20 de enero de 2004 11:23
Para: [EMAIL PROTECTED]
Asunto: unauthenticated use
On Wed, Oct 16, 2002 at 11:30:47AM +0800, Terence wrote:
> sql,query
>
> I have noticed an entry in the processlist which reads
>
> UserHostDBCommandState
> unauthenticated userconnecting host[blank]connectlogin
>
> Can someone shed some light on this for me? Whe
