MySQL Startup error

Service MySQL start times: error! The server quit without updating PID file (/usr/local/mysql/data/mysql1.pid), error.

1. Check the error log:

Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit Innodb_data_file_path In my.cnf back to what it is, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, and did not yet with them in any. But is careful:do not remove old data files which contain your precious data!

The discovery was caused by my.cnf this file configuration error.

2, VIM/ETC/MY.CNF

Increase:

Innodb_data_file_path=ibdata1:12m;ibdata2:10m:autoextend

The parameters are consistent with the existing table space, that is, the file size in the/usr/local/mysql/data/directory. Or just delete the ibdata1 ib_logfile0 ib_logfile1 These three files can also.

Start again, find or report the error. The acknowledgement was caused by a my.cnf file configuration error.

To modify the My.cnf file:

Comments:

#pid-file=/var/run/mysqld/mysqld.pid

#socket =/var/lib/mysql/mysql.sock

These two lines are commented out.

Start again and you will succeed.

MySQL Startup error