./mysql/user is marked as crashed 解决办法

最新推荐文章于 2024-03-07 09:29:15 发布

原创最新推荐文章于 2024-03-07 09:29:15 发布 · 703 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #service

本文提供了一种解决MySQL用户表出现问题的方法。通过使用skip-grant-tables参数启动MySQL服务，然后执行mysqlcheck命令修复受损的用户表。修复完成后，重新启动MySQL服务。

I found a solution to anyone else who may be having this problem.

First start mysql using skip grant tables

root@ns1 [/var/lib/mysql/mysql]# service mysql start --skip-grant-tables
Starting MySQL [ OK ]

now with mysql started, you can repair the mysql/user table

root@ns1 [/var/lib/mysql/mysql]# mysqlcheck -r mysql user
mysql.user
warning : Number of rows changed from 1558 to 1556
status : OK

now that its repaired, restart mysql

root@ns1 [/var/lib/mysql/mysql]# service mysql stop
Shutting down MySQLs [ OK ]
root@ns1 [/var/lib/mysql/mysql]# service mysql start
Starting MySQL [ OK ]

can someone confirm that this solution is ok?

参考网站地址： http://www.webhostingtalk.com/showthread.php?t=580813