Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve the problem that MySQL parameter files do not take effect". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

After starting the database, it was found that the parameter file did not take effect, and the default settings were used.

A closer look at the boot command reveals a Warning: World-writable config file '/etc/my_55_3306.cnf' is ignored

[root@tomcat02 ~]# /home/mysql_software_55/bin/mysqld_safe --defaults-file=/etc/my_55_3306.cnf &

[1] 19032

[root@tomcat02 ~]# Warning: World-writable config file '/etc/my_55_3306.cnf' is ignored

Warning: World-writable config file '/etc/my_55_3306.cnf' is ignored

180423 09:18:41 mysqld_safe Logging to '/home/mysql_software_55/data/tomcat02.err'.

180423 09:18:41 mysqld_safe Starting mysqld daemon with databases from /home/mysql_software_55/data

#View permissions for parameter files and find that other groups also have write permissions

[root@tomcat02 mysql_software_55]# ll /etc/my_55_3306.cnf

-rw-rw-rw- 1 root root 2252 Apr 23 12:24 /etc/my_55_3306.cnf

#Solution: Take back write permissions from other groups

[root@tomcat02 mysql_software_55]# chmod 644 /etc/my_55_3306.cnf

"How to solve the MySQL parameter file does not take effect" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.