How do I find out what my.cnf is being used?

Question

With MySQL, a my.cnf can be used specify configuration properties. MySQL may look in a variety of places to find this file, and if it doesn't find it may use built-in defaults.

How do you know what my.cnf is being used?

score 2 · Accepted Answer · answered Feb 09 '16 at 18:23

2

mysqld --help --verbose | grep -B 1 cnf

Beneath the "Default options are read from the following files in the given order:" line will be the locations MySQL is looking for the my.cnf file.

answered Feb 09 '16 at 18:23

drusolis

862
9
21

How do I find out what my.cnf is being used?

1 Answers1