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

標籤：provided   without   enabled   server   error   

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

重啟mysql報錯。

[[email protected] 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

[[email protected] 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