The error log is at:
/Applications/MAMP/logs/php_error.log
To avoid SQL using the wrong time, add –default-time-zone=’+00:00′ to the following file:
/Applications/MAMP/bin/startMysql.sh
To log all the queries that hit the database:
Login all the queries that hit your mysql database:
if you are running MAMP, edit
/Applications/MAMP/bin/startMysql.sh
and put this in the command line
–log=/Applications/MAMP/logs/mysql_query_log