MySQL log file disable

If you would like to dynamically stop logging, login as root@localhost and run this:

SET GLOBAL general_log = 'OFF';

That's it. No restart of mysql needed.

If you are not root@localhost, you will need to be logged in as a user with SUPER privilege.


In MySQL 5.1.12+ add/change this in your my.cnf

general-log = 0

In MySQL 5.1.11- remove this in your my.cnf

log

or

log = 

Source:

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_general_log

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_log