I'm fairly new to MySQL and I'm having some pretty basic
troubleshooting problems.

I have just installed MySQL from DarwinPorts on my OS X machine, and
although it's been running fine, I had not yet needed to modify the
default options. I recently needed to change the behavior or MySQL to
be more strict, so I determined that I needed to set sql-
mode=strict_trans_tables in my my.cnf file.

Unfortunately, I can't figure out for the life of me what my.cnf is
being used by mysqld. I tried modifying all the my.cnf files on my
machine (there were about 3, none of which were in /etc/ or /etc/
mysql), but that did not seem to work. I tried just putting the file
in /etc/ or /etc/mysql, but the option still did not change.

I looked around but I can't seem to find an option to mysqld to print
out where it is reading options from. I looked in the log file but I
don't see this information anywhere.

Can anyone tell me how to figure out which my.cnfs are being read by
mysqld? Once I determine which config files are being used I can
hopefully figure out a way to set the option quite easily.

Thanks!

Ben