mysqld_safe error: log-error set to '/data/mysql/log/mysqld.log', however file don't exists. ERROR! The server quit without updating PID file (/usr/local/mysql/mysqld.pid)

 

touch mysql.log

 

 

mysql启动报错

报错日志：

[root@mysql ~]# /etc/init.d/mysqld start
Starting MySQL.2020-12-15T12:00:26.431235Z mysqld_safe error: log-error set to '/data/mysql/log/mysqld.log', however file don't exists. Create writable for user 'mysql'.
ERROR! The server quit without updating PID file (/usr/local/mysql/mysqld.pid)

 

分析原因：

我的原因是因为没有my.cnf配置文件，有my.cnf.bak，又创建一个my.cnf配置文件

log-error set to '/data/mysql/log/mysqld.log', however file don't exists指定目录/data/mysql/log/看一下mysqld.log是否存在

再去数据库查看错误日志存放路径：mysql> show global variables like '%log_error%';

 

（通过log_error对应的路径为./mysql.err看和配置文件路径不一致）

正确应为：

 

 

解决方法：

在/data/mysql/log/目录下创建mysqld.log文件

touch mysqld.log

 

chown mysql:mysql mysqld.log

 

杀掉mysqld进程

pkill -9 mysqld

 

 重启mysqld(按照自己的启动方式来)

/etc/init.d/mysqld restart