早上到公司编辑反应后台登录不了,提示密码错误。
问了同事说没修改过密码,于是登录phpmyadmin查看site_user表。发现密码正确,于是使用原始mysql语句在phpmyadmin中执行,结果提示:
#1194 – Table ‘site_user’ is marked as crashed and should be repaired
于是按照提示:执行了
REPAIR TABLE `site_user`;
提示:
Table Op Msg_type Msg_text
site_db.site_user repair info Wrong bytesec: 232-141-163 at 73939404; Skipped
site_db.site_user repair info Wrong bytesec: 0- 0- 0 at 73939424; Skipped
site_db.site_user repair info Wrong bytesec: 105-103-115 at 73939384; Skipped
site_db.site_user repair warning Number of rows changed from 279630 to 279626
site_db.site_user repair status OK
然后后台登录就正常了。
遇到这种情况只需要修复一下问题表即可解决问题。