阿娇开发978 发表于 2018-10-11 08:42:38

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

  我在my.cnf中添加了一个log-bin=/data/docker/lisa/mysql/data/mysql-bin
  重启mysql报错。
  # 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 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 Aborting
  解决办法:
  #vim /etc/my.cnf
  添加一行
  server_id = 43306
  # service mysql restart
  ERROR! MySQL server PID file could not be found!
  Starting MySQL. SUCCESS!
  OK!!!

页: [1]
查看完整版本: Starting MySQL. ERROR! The server quit without updating PID file