Skip to content

Instantly share code, notes, and snippets.

@llagerlof

llagerlof/enable_mysql_query_log.sh

Created March 4, 2020 15:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save llagerlof/8e1142d4f0e8c7a895641e43baabab56 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save llagerlof/8e1142d4f0e8c7a895641e43baabab56 to your computer and use it in GitHub Desktop.
Download ZIP
Start logging all queries executed by MySQL server
Raw
enable_mysql_query_log.sh
# Must run as root in mysql cli
SET global log_output = 'FILE';
SET global general_log_file='mysql_sql.log';
SET global general_log = 1;
# Disable with SET global general_log = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment