Skip to content

Instantly share code, notes, and snippets.

@birchestx

birchestx/log_mysql.sql

Created June 5, 2016 20:14
Show Gist options
  • Save birchestx/582747802d01cc41fda19b1f516dd833 to your computer and use it in GitHub Desktop.
Save birchestx/582747802d01cc41fda19b1f516dd833 to your computer and use it in GitHub Desktop.
Download ZIP
Enable Logging myqsl
Raw
log_mysql.sql
Find your my.cnf:
mysql --help | grep "Default options" -A 1
Edit:
[mysqld]
general_log_file = /opt/local/var/log/mysql56/mysql-query.log
general_log = on
To check:
mysql -u root -p
show variables like '%log%';
You can also update in mysql - SET GLOBAL general_log = 'ON';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment