I got used to it that sometimes I need to check the queries run by MySQL. After clean OSX upgrade I forgot to enable it.
So I added the following to
[mysqld] sql_mode= general_log = 1 general_log_file = /usr/local/mysql/data/mysqld.query.log slow_query_log = 1 long_query_time = 1 # second slow_query_log_file = /usr/local/mysql/data/mysqld.slow.log log_queries_not_using_indexes = 0
The default one that comes with the package is at
There’s also an option to set logging via SQL queries.