MySQL - Enable query log

Would you like to learn how to enable the MySQL query log? In this tutorial, we are going to show you how to enable the MySQL query log on a computer running Ubuntu Linux.

• Ubuntu 18.04
• Ubuntu 19.04
• MySQL 5.7

Equipment list

The following section presents the list of equipment used to create this tutorial.

As an Amazon Associate, I earn from qualifying purchases.

Related tutorial - MySQL

On this page, we offer quick access to a list of tutorials related to MySQL.

Tutorial MySQL - Enabling the query log

Locate the configuration file of MySQL.

Edit the configuration file.

In the MYSQLD area, add the following lines.

As an example, here is our configuration file.

Restart the Mysql service.

Check the Mysql queries log.

In our example, we enabled the MySQL query log.