发布于 4年前

启动MySQL失败mysqld_safe error: log-error

报错提示：

[root@iZbp1dkipyap2xvhae0oyxZ local]# service mysql start
Starting MySQL.170814 20:02:33 mysqld_safe error: log-error set to '/usr/local/mysql/error.log', however file don't exists. Create writable for user 'mysql'.
The server quit without updating PID file (/usr/local/mysql[FAILED]bp1dkipyap2xvhae0oyxZ.pid).

已给mysql目录赋了权限了： chown -R mysql:mysql mysql

处理方案： 配置文件写错了,server_id 只能是个整数，写成了Ip地址