MySQL configuration file (my.cnf) file location depends on operating system or installation method. There are no command available to trace this file location on your system. In this tutorial you will get some default location’s of my.cnf file can be found.
- /etc/my.cnf
- /etc/mysql/my.cnf
- $MYSQL_HOME/my.cnf
- [DATADIR]/my.cnf
- ~/.my.cnf
In case my.cnf file is available on more than one place, system load each file and override configuration values.
2 Comments
Refer to:
https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/#configuration-syntax-and-groups
… You can see for each program which configuration files and groups it reads by executing program-name –help –verbose
sh> mysqld –help –verbose
Regards
Hi,
I wonder whether the excerpted lines from the output of the following command is system dependent:
mysqld –help –verbose
…
Default options are read from the following files in the given order:
/etc/my.cnf …