MySQL Start error report the server quit without updating PID file

MySQL installation time after installation failed to start error:

Starting MySQL. error! The server quit without updating PID file (/data/mysql/26765574162f.pid).

To view the error log:

[ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.user ' doesn ' t exist

Workaround:

1. Edit the configuration file:

Vim/etc/my.cnf

Basedir =/usr/local/mysqldatadir =/data/mysqlsocket =/tmp/mysql.socklog-error =/data/mysql/error.logpid-file =/data /mysql/mysql.piduser = Mysqltmpdir =/tmp

2. Reinitialize MySQL:

./mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql--pid-file=/data/mysql/mysql.pid- -tmpdir=/tmp

And then the boot will succeed:

MySQL Start error report the server quit without updating PID file