Skip to content

Instantly share code, notes, and snippets.

@abdes-zakari

abdes-zakari/Enable_MySQL_Query_Log.sql

Last active December 17, 2021 12:25
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 abdes-zakari/1400a4504b837c89bf289bc37617102d to your computer and use it in GitHub Desktop.
Save abdes-zakari/1400a4504b837c89bf289bc37617102d to your computer and use it in GitHub Desktop.
Download ZIP
Enable MySQL Query Log
Raw
Enable_MySQL_Query_Log.sql
//Enable MySQL Query Log
// To see global variable is enabled or not and location of query log
SHOW VARIABLES like 'general%';
// Set query log on
SET GLOBAL general_log = ON;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment