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

How to solve the MySQL configuration file specified log-error configuration item after the start error problem, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this can learn, I hope you can gain something.

After mysqld's configuration file my.cnf specifies log-error in the [mysqld_safe] configuration block, mysqld service startup reports an error exit because it cannot find the log file.

service mysql restart Shutting down MySQL.. [ OK ]Starting MySQL.180306 16:26:49 mysqld_safe error: log-error set to '/var/lib/mysql/mysql.log', however file don't exists. Create writable for user 'mysql'.The server quit without updating PID file (/var/lib/mysql//[FAILED]caldomain.pid).

This is a small bug in MySQL.

The temporary solution is to directly create an empty file specified by log-error and give appropriate owner and group permissions.

Question page: bugs.mysql.com/bug.php? id=84427

This issue has been fixed in versions 5.5.55, 5.6.36, 5.7.18, 8.0.1.

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

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.