Enable MySQL logging
Enabling MySQL log file:
In /etc/mysql/my.cnf, under Logging and Replication, uncomment log
# * Logging and Replication
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
log = /var/log/mysql/mysql.log
sudo /etc/init.d/mysql restart
tail -F /var/log/mysql/mysql.log
Turn it off when you’re done because:
* Impact on performance
* File size can grow quickly