Skip to content

Instantly share code, notes, and snippets.

@ph4r5h4d

ph4r5h4d/MySQL-Logging.md

Created December 1, 2020 10:24
Show Gist options
  • Save ph4r5h4d/428f9e17660c987758479f9d1be86b56 to your computer and use it in GitHub Desktop.
Save ph4r5h4d/428f9e17660c987758479f9d1be86b56 to your computer and use it in GitHub Desktop.
Download ZIP
Enable MySQL General Query Logging
Raw
MySQL-Logging.md

For enabling the general query logging:

SET global general_log = 1;
SET global log_output = 'table'

For disabling:

SET global general_log = 0;

You can query the table and see what happened:

select * from mysql.general_log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment