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
Subscribe
Notify of
guest

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

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments