OSX | Mysql | List location of log files

mysql-whereis-logs.sh

#!/usr/bin/env bash

mysql -se "SHOW VARIABLES" -u :user -p | grep -e log_error -e general_log -e slow_query_log


# Response:
#
# general_log	OFF
# general_log_file	/usr/local/var/mysql55/:user.log
# log_error	/usr/local/var/mysql55/:user.err
# slow_query_log	OFF
# slow_query_log_file	/usr/local/var/mysql55/:user-slow.log
##

$mysql -se "SHOW VARIABLES" -u :user -p | grep -e log_error -e general_log -e slow_query_log

# Response:
#
# general_log   OFF
# general_log_file  /usr/local/var/mysql55/:user.log
# log_error /usr/local/var/mysql55/:user.err
# slow_query_log    OFF
# slow_query_log_file   /usr/local/var/mysql55/:user-slow.log
##