Well look at that. I didn't look back to the Connect statement that starts the ID. Just when I think I'm getting a handle, I dive back into the quicksand! Ugh.
Thanks!!!! Lou ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 04, 2004 5:25 AM Subject: Re: Query Log > "Lou Olsten" <[EMAIL PROTECTED]> wrote: > > I'm pretty sure that the answer to this is "No, you cannot" but I figured I'd check > > anyway... > > > As I go back through my query log, I'd like to know the user that issued the statement. > > If the user is still connected, I can cross reference it with the SHOW PROCESSLIST ID, > > but if they have signed off, is there a way to get the user then? > > If you look in the general query log file you can see Id column where thread id is specified and username and host in the Argument column. > For update log and slow query log use --log-long-format option. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]