Posted on

Finding the my.cnf Which Is Actually Loaded

sudo dtruss mysqld 2>&1|grep my.cnf

/usr/local/mysql/data$ sudo dtruss mysqld 2>&1 | grep my.cnf
Password:

stat64("/etc/my.cnf\0", 0x7FFF5548E548, 0x7FFF5548F300)		 = -1 Err#2
stat64("/etc/mysql/my.cnf\0", 0x7FFF5548E5dtrace: error on enabled probe ID 2135 (ID 940: syscall::read_nocancel:return): invalid kernel access in action #12 at DIF offset 92
stat64("/usr/local/mysql/etc/my.cnf\0", 0x7FFF5548E548, 0x7FFF5548F300)		 = 0 0
open_nocancel("/usr/local/mysql/etc/my.cnf\0", 0x0, 0x1B6)		 = 3 0
stat64("/Users/jennifer/.my.cnf\0", 0x7FFF5548E548, 0x1000)		 = -1 Err#2

open_nocancel("/usr/local/mysql/etc/my.cnf\0", 0x0, 0x1B6) = 3 0
is the line to look for