Log all queries in MySQL

Better Stack Team
Updated on November 23, 2022

In MySQL, it is possible to log all queries that were executed. You can view them as a table or file.

Output query history into a table

To output executed queries into a table, run the following MySQL commands:

 
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';

Then, take a look at mysql.general_log table, where you see the query history:

 
SELECT * FROM mysql.general_log

Output query history into a file

To output query history into a file instead of a table, run the following MySQL commands:

 
SET GLOBAL log_output = "FILE";
SET GLOBAL general_log_file = "/path/to/your/logfile.log";
SET GLOBAL general_log = 'ON';

Don’t forget to replace "/path/to/your/logfile.log" with the actual log file you wish to use. Then you can just open the file to see query history. To see the last 10 line, run the following command:

 
tail /path/to/your/logfile.log

Make your mark

Join the writer's program

Are you a developer and love writing and sharing your knowledge with the world? Join our guest writing program and get paid for writing amazing technical guides. We'll get them to the right readers that will appreciate them.

Write for us
Writer of the month
Marin Bezhanov
Marin is a software engineer and architect with a broad range of experience working...
Build on top of Better Stack

Write a script, app or project on top of Better Stack and share it with the world. Make a public repository and share it with us at our email.

community@betterstack.com

or submit a pull request and help us build better products for everyone.

See the full list of amazing projects on github