MySQL does not start: Table mysql.host doesn t exist! Error 1067 occurred, resolved.

The MySQL service does not start, start with a command or start the Times in the service window wrong: Error 1067 occurred

And then looked for a long time their own modified My.ini put all tried, useless

When you open the error log, the last line shows:

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

And then go and find out what to do.

Is the MySQL database has a problem, specifically, the user table has a problem.

Online solutions are mostly Linux, initialize the database is OK, that is: mysql_install_db--user=mysql

This trick is not available under Windows.

To the data directory, the MySQL folder has not been deleted. Then copy the file from the downloaded mysql.zip.

or Data\mysql directory, User.frm,user cannot be found. Myd,user. Myi three files, that is, the user table was deleted.

Or you can copy the three files from the downloaded mysql.zip.

OK, perfect solution.

Of course, the original user name password all reset.

MySQL does not start: Table mysql.host doesn t exist! Error 1067 occurred, resolved.