mysql.proc 显示代码,表'./mysql/proc'被标记为已崩溃，应该修复

When i perform any procedure creation or update operation to mysql DB, i am getting the below error

Table './mysql/proc' is marked as crashed and should be repaired

Tried to run mysql isam recover using below command -

myisamchk -q -r /var/lib/mysql/mysql/proc

But the issue still persists.

Thanks in Advance.

解决方案

Try these:

mysqlcheck --auto-repair -A -u username -ppassword

Inside MySQL terminal

repair table mysql.proc;

[mysqld]

character-sets-dir=/usr/share/mysql/charsets