I can exploit this feature to find out EXACTLY where my log files are, like so: /opt/local/libexec/mysqld -verbose -help|grep '^log' The values are the result of your compile time configuration, my.cnf file, and any command line options. The mysqld can be called with -verbose -help to get a list of all command line options (and here is the important/valuable part!) followed by the values that would be used if you were launching mysqld instead of just checking the help output. Let's take this lesson a bit further.įrom the first line you can see the my daemon is /opt/local/libexec/mysqld. Root 76 0.0 0.0 600172 688 ? S 12:30AM 0:00.02 /bin/sh /opt/local/lib/mysql/bin/mysqld_safe -datadir=/opt/local/var/db/mysql -pid-file=/opt/local/var/db/mysql/rbronosky-mbp.pidįrom that you can see that my datadir is /opt/local/var/db/mysql (because I installed via MacPorts). # Note: For zsh compatibility put quotes around the grep regexĬan you post the result of that command here please? Mine looks like this: _mysql 101 0.0 0.3 112104 13268 ? S 12:30AM 0:13.20 /opt/local/libexec/mysqld -basedir=/opt/local -datadir=/opt/local/var/db/mysql -user=mysql -pid-file=/opt/local/var/db/mysql/rbronosky-mbp.pid # to keep it from matching its own process. # Putting brackets around the first char is a `grep`+`ps` trick The following command will give you (and us) a good indication of where to look. Each of which will place your data dir and/or logs in different locations. As Chealion mentioned, there are several ways that your mysql could have been installed.

Date issue in mysql for mac