Bug #28232 Need separate logs for different databases / users
Submitted: 4 May 2007 8:42 Modified: 17 Jul 2007 10:22
Reporter: media forest Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.38-1 OS:Any
Assigned to: CPU Architecture:Any

[4 May 2007 8:42] media forest
I run a server with several virtual domains, several databases and several users.

For debugging and security purpose, I'd like to be able to log separately the queries sent to each database or sent by each user. 

How to repeat:
I know that binlog permits to get separates datas for differents databases, but it's not possible to "tail" its output and furthermore it only logs the changes
to databases, not the SELECT queries. 
It's why for now I still use mysql.log but the use of :
tail -f /var/log/mysql/mysql.log
is a bit confused if there are many queries sent at the same time, and it's not possible to filter the output with grep 
as the database name is only written on the first line of a query.

Suggested fix:
I've looked for a workaround on many forums, asked this question many times, but I never got any answer.
[5 May 2007 6:52] Valeriy Kravchuk
Thank you for a reasonable feature request.
[17 Jul 2007 10:22] media forest
Is it planned that someone work on this feature ?