November 19, 2006
How MySQL Loads Configuration Options
A quick refresher on the locations MySQL uses to load up configuration options on Unix:
- $MYSQL_HOME/my.cnf (sometimes this is your datadir, other times it's basedir)
- command line arg (defaults-extra-file)
- user's home directory (~/user/.my.cnf)
It's available in the MySQL docs, and there's a section on it in Pro MySQL, but it seems a need to remember the exact order only comes often enough to confirm that I haven't committed it to long-term memory.
Posted by mike at November 19, 2006 10:07 PM