Determine which MySQL configuration file is being used

mysql configuration
yalestar picture yalestar · Feb 24, 2009 · Viewed 197.8k times · Source

Is there a command to determine which configuration file MySQL 5.0 is currently using?

Answer

Mark B picture Mark B · May 24, 2010

Taken from the fantastic "High Performance MySQL" O'Reilly book:

$ which mysqld
/usr/sbin/mysqld

$ /usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"
Default options are read from the following files in the given order:
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf

Related questions

I can not find my.cnf on my windows computer

My computer is Windows XP. I need to find my.cnf to get all privileges back to the root user. I accidentally removed some privileges of the root user. I still have the password and there is no problem for …

Read More
Changing Font in MySQL Workbench

I am using MySQL Workbench 5.2, the newest version as far as I know, but I simply cannot change the font. It is very inconvenient, because the default font is very small and harsh on the eyes. The appearance tab has …

Read More
How to get rid of STRICT SQL mode in MySQL

This is a follow up to this question MYSQL incorrect DATETIME format How to get rid of STRICT_TRANS_TABLES once and for all? mysql --help reports the following configs: Default options are read from the following files in the …

Read More