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
© 2019, Techrunnr. All rights reserved.