Habilitar query log en MySQL

Editar el archivo /etc/mysql/my.cnf y agregar al final del archivo:

[mysqld]
general_log=on
general_log_file=/var/log/mysql/query.log

Reiniciar el servicio

service mysql restart

Revisamos la salida

tail -f /var/log/mysql/query.log
jaime Avatar

Written by

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.