Skip to content

Instantly share code, notes, and snippets.

@vanzhiganov
Forked from joseluisq/mysql_query_log.md
Created February 3, 2023 07:24
Show Gist options
  • Save vanzhiganov/f5c46542f440f3e32a4e9e737f8f1f2a to your computer and use it in GitHub Desktop.
Save vanzhiganov/f5c46542f440f3e32a4e9e737f8f1f2a to your computer and use it in GitHub Desktop.
How to enable the MySQL/MariaDB general query logs

How to enable the MySQL/MariaDB general query logs

  1. Enter to MySQL/MariaDB server command-line tool (change root with your username and password):
mysql -u root -proot
  1. Set the general log file path:
SET GLOBAL general_log_file='/var/log/mysql/mycustom.log';
  1. Set the log output to file format:
SET GLOBAL log_output = 'FILE';
  1. Enable the server general log:
SET GLOBAL general_log = 'ON';
  1. Show the general log settings:
SHOW VARIABLES LIKE "general_log%";
  1. Try to execute your own SQL query from your app or command-line tool...

  2. View the general log file content:

less /var/log/mysql/mycustom.log
  1. Disable the general server log:
SET GLOBAL general_log = 'OFF';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment