#To have Mysql logs, you have to activate the query logging in mysql.
#1. Edit the <path to your mysql server>/my.cnf file:
#To enable error log add following
[mysqld_safe]
log_error=/var/log/mysql/mysql_error.log
[mysqld]
log_error=/var/log/mysql/mysql_error.log
#To enable general query log add following
general_log_file = /var/log/mysql/mysql.log
general_log = 1
#To enable Slow Query Log add following
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
#2. Restart the computer or the mysqld service
service mysqld restart
#3. Read the log or
cat /var/log/mysql/mysql.log
#or read real-time
tail -f /var/log/mysql/mysql.log