MySQL 5.5 - General log for only one account

kszadkowski

• September 30, 2014 03:25

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

  • September 30, 2014 13:38

  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: [url=http://dev.mysql.com/doc/refman/5.5/en/query-log.html]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.

  0

Please sign in to leave a comment.