The mysql pid file cannot be started after it is deleted. How can this problem be solved?

The mysql pid file cannot be started after it is deleted. How can this problem be solved?

Tip: "Starting MySQL ...... ERROR! Manager of pid-file quit without updating file "solution.

After you delete the mysql binary log file and restart mysql, this error occurs because the disk space is small and those binary files occupy a lot of space. So you need to delete it. The solution was to enter the mysql var directory cd

/Usr/local/mysql/var/, and then vi

Mysql-bin.index, just remove the binary log file you deleted. If the problem persists, view the *. err file in the var directory for further judgment.

How to disable mysql binary files:

Vi/etc/my. cnf

Log-bin = mysql-bin

Binlog_format = mixed

Comment out the two lines and restart them.