在创建角色并给角色授权时共出现了以下两个错误(出现错误的原因暂时未知):
Index for table 'db' is corrupt; try to repair it
Table 'tables_priv' is marked as crashed and should be repaired
解决方案
(乖乖听提示的话,repair就可以了)
具体操作:
- 进入mysql客户端
- 找到左侧数据库“mysql”
- 通过SQL语句repair:
REPAIR TABLE
`db`;
REPAIR TABLE
`tables_priv`;
- 点击“执行”或"ctrl + enter"