An unexpected error with MySQL

This morning visit webpage, prompt error, database connection not on, then restart MySQL service, prompt

MySQL Manager or server PID file could not being found!

Starting mysql.manager of Pid-file quit without updating fi

Good depressed, and then look at the error log, there is such a hint:

150814 12:04:09 [ERROR]/usr/local/mysql/bin/mysqld:table './mysql/user ' is marked as crashed and last (automatic?) Repai R failed

150814 12:04:09 [ERROR] Fatal Error:can ' t open and lock Privilege tables:table './mysql/user ' is marked as crashed and L AST (automatic?) repair failed

Can only read the small part, said I this user table as if the repair failed, never encountered this error, so the morning to check the information, tried several unsuccessful, and finally accidentally saw an article:

1 access to the installation path of your database mine is/data/mysql/mysql.

2 run myisamchk-of user. MYI fix my user table appears the following prompt indicates success:

-Recovering (with Keycache) myisam-table ' user. MYI '
Data Records:6

3 Restart MySQL service again, success.

Reference article: http://www.jb51.net/article/33627.htm

This article is from the "Linux" blog, so be sure to keep this source http://825536458.blog.51cto.com/4417836/1684627

An unexpected error with MySQL