How to enable the MySQL query logs
- By Preneesh AV --
- 11-Jun-2019 --
- 142 Comments
Go to phpMyAdmin and run following command:
Enable Query logging on the database(Note that the string 'table' should be put literally and not substituted by any table name..
SET global general_log =1;SET global log_output ='table';
- View the log
select*from mysql.general_log;
- Disable Query logging on the database
SET global general_log =0;