To Enable Mysql General Log

Log — Tags: MySQL — Posted by Starck on October 17, 2013

Edit my.cnf:

general_log=1
general_log_file=/path/mysql.log

1 2	general_log=1 general_log_file=/path/mysql.log

You can also rename the general query log file at runtime by disabling the log:

SET GLOBAL general_log = 'OFF';

With the log disabled, rename the log file externally; for example, from the command line. Then enable the log again:

SET GLOBAL general_log = 'ON';