Table './mysql/user' is marked as crashed and should be repaired
How to make mysql service online from crash!
mysqld started
[ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
[ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
[ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
mysqld ended
Which means DB: /var/lib/mysql/mysql table: "user" has been crashed.
To resolve this issue, please perform the commands below:
root@ranjith [/var/lib/mysql/mysql]# service mysql start --skip-grant-tables
now with mysql started, you can repair the mysql/user table
root@ranjith [/var/lib/mysql/mysql]# mysqlcheck -r mysql user
or
Repair ALL database tables thorugh:
http://techietent.blogspot.in/
After that,
root@ranjith [/var/lib/mysql/mysql]# service mysql stop
Shutting down MySQLs [ OK ]
root@ranjith [/var/lib/mysql/mysql]# service mysql start
Starting MySQL [ OK ]
root@ranjith [/var/lib/mysql/mysql]#
cheers!!!
Thanks a million. This is a lifesaver!
ReplyDeleteyou're welcome
DeleteGreat article, we provide wordpress management services and have recommended this article to many of your clients. Great post and it works!
ReplyDeleteThank you !
Delete