Enabling general queries log in MySQL server

Create a log:

touch /var/log/mysqld-general.log

Set the permissions:

chown mysql:mysql /var/log/mysqld-general.log

Run in mysql console:

mysql> SET GLOBAL general_log_file='/var/log/mysqld-general.log';
mysql> SET GLOBAL general_log = 1;


Leave a Reply

Your email address will not be published.