Start MySQL Error--error! The server quit without updating PID file

Development said that a test environment of MySQL, unable to restart, reported the following error message:

# service mysqld restartshutting down MySQL. success! Starting MySQL. error! The server quit without updating PID file (/usr/local/mysql/data/test.pid). # ps-ef|grep mysql|grep-v Grepavahi      697
   1  0 Sep16?        00:00:02 avahi-daemon:running [test.local]# service mysqld startstarting MySQL. error! The server quit without updating PID file (/usr/local/mysql/data/test.pid).

　

Looked at the error log, actually did not have any hint. Ask him what he did before restarting the operation did not, replied that just opened the binary, and then try to restart the error.

Looking at the my.cnf file, it does add a parameter:

Log_bin=binlog

　　

However, if Server-id is not set, a Server-id is set in the configuration file:

Server-id=1

　　

Restart success!

The cause of the error can be seen in the Official Document Setup Log-bin section:

If you specify this option without also specifying a--server-id, the server was not allowed to start. (Bug #11763963, bug #56739)

　　

Start MySQL Error--error! The server quit without updating PID file