标题: 重启之后mysql起不来，报错Starting MySQL. ERROR! Manager of pid-file quit without updating [打印本页] 作者: cheanshun 时间: 2014-4-11 18:32 标题: 重启之后mysql起不来，报错Starting MySQL. ERROR! Manager of pid-file quit without updating 军哥求助
重启之后mysql起不来，报错Starting MySQL. ERROR! Manager of pid-file quit without updating file
MYSQL日志：
140411 16:02:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 16:02:49 [ERROR] You need to use --log-bin to make --binlog-format work.
140411 16:02:49 [ERROR] Aborting 140411 16:02:49 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 16:02:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended
140411 17:27:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 17:27:30 [ERROR] You need to use --log-bin to make --binlog-format work.
140411 17:27:30 [ERROR] Aborting 140411 17:27:30 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 17:27:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended
140411 18:11:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 18:11:06 [ERROR] You need to use --log-bin to make --binlog-format work.
140411 18:11:06 [ERROR] Aborting 140411 18:11:06 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 18:11:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended作者: cheanshun 时间: 2014-4-11 18:55
已解决，修改/ect/my.cnf 把binlog_format=mixed注释掉，mysql启动成功