List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 18 2000 5:21pm
Subject:unknown user?
View as plain text  
>>>>> "Piet" == Piet Wesselman <pwessel@stripped> writes:

Piet> Does anyone know what this result means? I don't like unknown users sleeping
Piet> in my db...

mysql> show processlist\g
Piet> +--------+--------------+--------------+-----------+---------+------+-------
Piet> +------------------+
Piet> | Id     | User         | Host         | db        | Command | Time | State
Piet> | Info             |
Piet> +--------+--------------+--------------+-----------+---------+------+-------
Piet> +------------------+
Piet> | 390488 | admin        | dusty        | antiqbook | Query   | 0    | NULL
Piet> | show processlist |
Piet> | 391375 | unknown user | unknown host | NULL      | Sleep   | NULL | login
Piet> | NULL             |
Piet> +--------+--------------+--------------+-----------+---------+------+-------
Piet> +------------------+

Hi!

The above means that you did 'process list' while on thread was
negotiation a connection;  In other words, the user hasn't yet logged
in;  Nothing to worry about.

Regards,
Monty
Thread
unknown user?Piet Wesselman18 Jan
  • Re: unknown user?sinisa18 Jan
  • unknown user?Michael Widenius18 Jan
    • Re: unknown user?Tim Bunce19 Jan
  • Re: unknown user?Jeremy Cole19 Jan
    • Re: unknown user?Tim Bunce20 Jan
Re: unknown user?Piet Wesselman20 Jan