mysql数据库只能建不能删的错误提示及处理方法:
mysql> drop database zabbixaa;
ERROR 145 (HY000): Table ‘./mysql/proc‘ is marked as crashed and should be repaired
处理方法:直接在mysql数据库里面使用root帐号登录后,进行修复:
mysql> repair table mysql.proc;
+------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------+--------+----------+----------+
| mysql.proc | repair | status | OK |
+------------+--------+----------+----------+
1 row in set (0.05 sec)
再次执行删除正常
mysql> drop database zabbixaa;
Query OK, 0 rows affected (0.02 sec)
修复./mysql/proc
标签:stat 方法 data cte l数据库 cpp row 登录 query
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:https://www.cnblogs.com/xzlive/p/9914326.html