Log to record activity against a database

Posted on

Question :

I’ve been assigned to create a general log.

I need a log that captures what actions were taken, by whom, to the database. Regardless of whether it is a SELECT or an ALTER or etc. We need to keep track of everything that users have been doing to the database.

I have already created a general log to my localhost as a “mouse lab”. However, there are no records inserted into the general log table.

What can you suggest I do? I’m using MySQL.

I’m losing myself on this, and I have no idea what to do anymore. I’m just a freshie, not even graduated.

Answer :

You can enable general log by adding this line in my.cnf/my.ini file:

also You can set General log output by changing your my.cnf/my.ini file (MySQL configuration file) to either TABLE or FILE if TABLE is choosen then server will log all queries in general_log table of mysql schema otherwise in FILE option it will log in a file path mentioned.

Leave a Reply

Your email address will not be published. Required fields are marked *