Mysql my.cnf Location

Reference mysql configuration

  • Linux/Unix
/etc/my.cnf Global options
SYSCONFDIR/my.cnf Global options
$MYSQL_HOME/my.cnf Server-specific options
defaults-extra-file The file specified with —defaults-extra-file=path, if any
~/.my.cnf User-specific options
  • Windows
WINDIR\my.ini, WINDIR\my.cnf Global options
C:\my.ini, C:\my.cnf Global options
INSTALLDIR\my.ini, INSTALLDIR\my.cnf Global options
defaults-extra-file The file specified with —defaults-extra-file=path, if any