首页 > 数据库技术 > 详细

Starting MySQL. ERROR! The server quit without updating PID file

时间:2016-12-28 19:19:29      阅读:165      评论:0      收藏:0      [点我收藏+]

我在my.cnf中添加了一个log-bin=/data/docker/lisa/mysql/data/mysql-bin

重启mysql报错。

[root@6e05ca49e205 data]# service mysql restart

Shutting down MySQL.. SUCCESS! 

Starting MySQL. ERROR! The server quit without updating PID file (/data/docker/lisa/mysql/data//6e05ca49e205.pid).


怎么办??

查看我的errorlog

# tail -f 50 b0d81312ea9e.err

2016-12-28T07:58:19.333819Z 0 [ERROR] You have enabled the binary log, but you haven‘t provided the mandatory server-id. Please refer to the proper server start-up parameters documentation

2016-12-28T07:58:19.333854Z 0 [ERROR] Aborting


解决办法:

#vim /etc/my.cnf

添加一行

server_id = 43306


[root@b0d81312ea9e data]# service mysql restart

ERROR! MySQL server PID file could not be found!

Starting MySQL. SUCCESS! 

OK!!!


Starting MySQL. ERROR! The server quit without updating PID file

原文:http://songlisha.blog.51cto.com/6269280/1886946

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!