MySQL Configuration path

1) about the configuration file path

Sometimes I find that although I try to modify some variables of the configuration file, it does not take effect. It turned out that the modified file was not a configuration file read by the MySQL server.

If you don't know the profile path currently used by MySQL, you can try this:

/usr/local/zend/mysql/bin/mysqld--verbose--help | Grep-a 1 ' Default options '

141020 17:34:05 [ERROR] Can ' t find messagefile '/usr/local/mysql/share/errmsg.sys '

141020 17:34:05 [Warning] Can ' t ' Create test File/usr/local/mysql/data/zhepamadeimac.lower-test

141020 17:34:05 [Warning] Can ' t ' Create test File/usr/local/mysql/data/zhepamadeimac.lower-test

/usr/local/zend/mysql/bin/mysqld:can ' t change dir to '/usr/local/mysql/data/' (errcode:2)

141020 17:34:05 [Note] Plugin ' federated ' is disabled.

/usr/local/zend/mysql/bin/mysqld:unknown Error 1146

141020 17:34:05 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.

Default options is read from the following files in the given order:

/ETC/MY.CNF/ETC/MYSQL/MY.CNF/USR/LOCAL/MYSQL/ETC/MY.CNF ~/.my.cnf

MySQL Configuration path