Skip to content

Instantly share code, notes, and snippets.

@caingougou

caingougou/enable_mysql_general_log.sql

Created May 23, 2013 03:37
Show Gist options
  • Save caingougou/5632599 to your computer and use it in GitHub Desktop.
Save caingougou/5632599 to your computer and use it in GitHub Desktop.
Download ZIP
Enable mysql general log at runtime
Raw
enable_mysql_general_log.sql
SET GLOBAL log_output = "FILE"; which may be set by default, I think.
SET GLOBAL general_log_file = "/var/log/mysql/my.log";
SET GLOBAL general_log = 'ON';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment