今天在折騰MySQL的參數文件時，突然發現MySQL 5.6.20-enterprise-commercial-advanced-log這個版本數據庫的參數文件my.cnf的位置有點奇怪，如下所示：

?

[root@DB-Server ~]# mysql --help | grep my.cnf????????????????????? order of preference, my.cnf, $MYSQL_TCP_PORT,/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf [root@DB-Server ~]# ls -lrt /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf ls: /etc/my.cnf: No such file or directoryls: /etc/mysql/my.cnf: No such file or directoryls: /usr/etc/my.cnf: No such file or directoryls: /root/.my.cnf: No such file or directory[root@DB-Server ~]# locate my.cnf/usr/my.cnf[root@DB-Server ~]# find / -name "my.cnf"/usr/my.cnf

?

?

?

我們知道MySQL啟動的時候，會先去讀取參數文件my.cnf中的參數去初始化，默認情況下，MySQL會按一定的順序來讀取參數文件，這個順序為/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf? 但是，在這個MySQL版本中my.cnf 參數文件位于/usr/my.cnf下，Why？ 一頭懵逼！ 然后我測試了一下其它版本，例如mysql-community-server-5.7.18，確實都是位于指定的目錄，如下所示

?

?

[root@gettestlnx02 ~]# locate my.cnf????? /etc/my.cnf/etc/my.cnf.d[root@gettestlnx02 ~]# strace mysql ";" 2>&1 | grep my.cnfstat64("/etc/my.cnf", {st_mode=S_IFREG|0644, st_size=979, ...}) = 0open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) = 3stat64("/etc/mysql/my.cnf", 0xffc0f4a0) = -1 ENOENT (No such file or directory)stat64("/usr/etc/my.cnf", 0xffc0f4a0)?? = -1 ENOENT (No such file or directory)stat64("/root/.my.cnf", 0xffc0f4a0)???? = -1 ENOENT (No such file or directory)[root@gettestlnx02 ~]#? rpm -qf? /etc/my.cnfmysql-community-server-5.7.18-1.el6.i686[root@gettestlnx02 ~]#

?

?

?

?

后面搜索了一下，發現這居然是一個bug來著。具體參考下面鏈接

?

https://bugs.mysql.com/bug.php?id=68318

https://bugs.mysql.com/bug.php?id=71600

?

With recent MySQL 5.6 versions, the RPM installation generate a non-standard /usr/my.cnf file overriding the sql_mode set in /etc/my.cnf as per:?https://bugs.mysql.com/bug.php?id=71600

This occurs during upcp when minor MySQL updates are installed and breaks some sites due to "STRICT_TRANS_TABLES".

Please add the flag --keep-my-cnf when executing mysql_install_db or otherwise remove the /usr/my.cnf file after MySQL upgrade during upcp to remove this unexpected change.

?

?

?

參考資料：

?

https://features.cpanel.net/topic/disable-creation-of-usrmy-cnf-when-mysql-is-installed

https://bugs.mysql.com/bug.php?id=71600

轉載于:https://www.cnblogs.com/kerrycode/p/7205590.html

總結

以上是生活随笔為你收集整理的MySQL 5.6.20-enterprise-commercial的参数文件位置问题的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。