MySQL 5.5 - General log for only one account

[kszadkowski]

cPanel 11.44.1
MySQL 5.5

My client needs for some time logging all operations on his database. I would like to start the general log, but only for one account. When you turn on the general log in my.cnf, its starts to log all traffic to all databases, cuz the file is expanding at a terrible time.

Is it possible to start the general log but only for one account?

 

[cPanelMichael]

Hello

It's a global log file so it's not possible to enable it for specific databases. You can find documentation on it here:

MySQL :: MySQL 5.5 Reference Manual :: 5.2.3 The General Query Log

Note that you could enable it globally and then grep the log file for the specific database.

Thank you.