Starting MySQL in Linux. error! The server quit without updating PID file error

Starting MySQL. error! The server quit without updating PID file (/usr/local/mysql/var/***.pid)

Today, restart the server or LNMP service when the above prompts, groping for a long time, is the manual deleted the MySQL log file out of the problem, the solution is directly to the MySQL log off, and then the normal start.

Close the MySQL log for Lnmp as follows:

How to turn off the MySQL log feature:

To delete a log:

Executive:/usr/local/mysql/bin/mysql-u root-p

Enter password login and then execute: RESET master;

Close log:

Modify the/etc/my.cnf file to find

Log-bin=mysql-bin
Binlog_format=mixed

Then add the # to the two lines, comment them out, and then execute/etc/init.d/mysql restart.