Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

Today, after installing the mysql-5.1.73 software with a one-click installation of MySQL shell script, I found that MySQL always failed to start, after many executions still error, only to see the error log, found the following 2 errors:

Error One: Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

Error Two: InnoDB:Error:combined size of log files must be < 4 G

Obviously, error one indicates that there is a system table missing, error Two means that the total size of redo log is over 4GB.

The query https://bugs.mysql.com found that this is a bug, and the answer on StackOverflow is basically:

Delete MySQL installation related files such as:/etc/my.cnf,/usr/bin/mysql,/var/lib/mysql and $datadir folder, and then restart the server, install again.

Link here: https://stackoverflow.com/questions/9083408/ Fatal-error-cant-open-and-lock-privilege-tables-table-mysql-host-doesnt-ex

After the installation is successful, check your installation script to see that there are no commands to delete the $datadir folder.

Guess is because the first time wget downloaded the installation package due to network reasons a little accident, resulting in the first generation of the data file in the system table space is missing the Mysql.host table, resulting in a failure to start the error.

The error two is a companion error, the data file under the Ib_logfile is not deleted, resulting in two installations to generate logfile when the total capacity was found to exceed 4GB (this limit is modified to 512GB after 5.6.2).

Finally, complete the next installation script, add the command to delete the data file.

Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist