Skip to content

Instantly share code, notes, and snippets.

@chriskief

chriskief/log_on.sql

Last active August 29, 2015 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chriskief/5629fbc6d849dd7ad697 to your computer and use it in GitHub Desktop.
Save chriskief/5629fbc6d849dd7ad697 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
log_on.sql
mysql> SHOW VARIABLES LIKE "general_log%";
+------------------+-----------------------------------+
| Variable_name | Value |
+------------------+-----------------------------------+
| general_log | OFF |
| general_log_file | /opt/local/var/db/mysql56/out.log |
+------------------+-----------------------------------+
2 rows in set (0.00 sec)
mysql> SET GLOBAL general_log = 'ON';
Query OK, 0 rows affected (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment