Speaktech.in

How to enable the MySQL query logs

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;