MySQL Problem: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted

Question

 

We have upgraded MySQL fom 5.0 to 5.5 after upgradation we are getting this error

MySQL Problem: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted

 

Any idea?

 

Answer 1

There is some bug in mysql which causes error when moving database from 5.0 to 5.5, or not upgraded properly To fix this you need to run

mysql_upgrade --force -uroot -p

(then enter your mysql root password) . You have to use the--force option or else it won’t fix the problem. I hope this will save someone's time.