首页 > 代码库 > Starting MySQL. ERROR! The server quit without updating PID file
Starting MySQL. ERROR! The server quit without updating PID file
我在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