排查流程
net start mysql
无法启动mysql,发生系统错误1067
查看事件日志提示:Table '.\mysql\user' is marked as crashed and should be repaired
。
user表索引文件损坏
解决办法
找到mysql的安装目录的bin/myisamchk工具,在命令行中输入:
myisamchk -c -r ../data/mysql/user.MYI #修复mysql user表索引
参考文章:
[MySQL]快速解决"is marked as crashed and should be repaired"故障