Skip to content

Instantly share code, notes, and snippets.

@ph4r5h4d

ph4r5h4d/MySQL-Logging.md

Created December 1, 2020 10:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ph4r5h4d/428f9e17660c987758479f9d1be86b56 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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