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.