MySQL Startup error: Table ' mysql.host ' doesn ' t exist

Today after installing MySQL, boot time did not start successfully, check the following log error as follows:

---------------------------------------------

[Email protected] local]# Less/var/log/mysqld.log

1. Check the error message as follows:

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

2, after access to information learned. To hit the following command to resolve:

Mysql_install_db–usrer=mysql Datadir=/var/lib/mysql

DataDir is my MySQL storage file directory

3. Then restart MySQL or not:

MySQL Daemon failed to start.

Starting mysqld: [Failed]

4, and then tried the next separate command, start to complete

mysql_install_db

5. Start the MySQL service

[Email protected] mysqld]#/etc/init.d/mysqld restart

Stop mysqld: [OK]

Starting mysqld: [OK]

------------------------

Dylan Presents

This article is from the "Frozen vs watermelon" blog, so be sure to keep this source http://molewan.blog.51cto.com/287340/1773478

MySQL Startup error: Table ' mysql.host ' doesn ' t exist