Shulou(Shulou.com)06/01 Report--

Recently, encountered a strange problem, mysql use--defaults-file specified my.cnf to start the database, the result every time the error log_timestamps

Invalid argument. The error is as shown in the figure:

As can be seen from the above figure:

1. mysql startup does use--defaults-file to specify a specific my.cnf

2. The startup error log_timestamps parameter cannot be recognized.

In order to exclude this parameter from causing the mysql instance to fail to start, I removed this parameter from my.cnf. Unexpectedly, the mysql startup error was still reported. Here,

I think mysql startup essentially uses my.cnf instead of--defaults-file. So I checked/etc/my.cnf, and sure enough,/etc has

My.cnf, log_timestamps are configured under [mysqld]. There is a problem with the characters, and the square brackets in Chinese are quoted. It also reminds us:

mysql instance startup reads my.cnf is sequential:

mysql index my.cnf file order

[root@centos7mysql ~]# mysql --help | grep .cnf

order of preference, my.cnf, $MYSQL_TCP_PORT,

/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

[root@centos7mysql ~]#

Because we specified my.cnf for mysql instance startup, I removed my.cnf from/etc and used--defaults-file again.

Start mysql can start smoothly.

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.