log user activities in MYSQL1 min read
Hi All, this document deals with how to log user activities in MYSQL.
It is always required to log all the user activities happening in MySQL when a server is used by multiple persons or application.
So here are the steps to achieve it.
Step 1: Login to the Mysql server.
Step 2: Create a General log file.
Step 3: Enable the general log
Add the following to /etc/my.cnf
Step 4: If you also want the text version of the general log, add this:
Step 5: Restart MySQL