首页 > 开发 > MySQL > 正文

启动MySQL失败mysqld_safe error: log-error

2017-09-08 08:51:09  来源:网友分享

报错提示:

[root@iZbp1dkipyap2xvhae0oyxZ local]# service mysql startStarting 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

解决方案

sorry,我的配置文件写错了
server_id只能是个整数,我写了个Ip地址(该打)