I remember reading about someone inquiring about including the user's information in each query logged to the binlog. Neither "mysqlbinlog" or "show binlog events" shows which user performed which changes to the database (at least for me:4.1.1a-alpha-nt-log / binary distro ) . Is that information available somewhere else? I just spent the last hour or so trying to dig that old thread out of the archives (I have been using Google and the search page at lists.mysql.com) but I just can't seem to find it. Could someone please help point me back to that old thread?
Shawn:
Enable both log and log-bin. Then you can match the thread_id field in mysqlbinlog output with the Connect command and track down the user.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
