2 like 0 dislike
1.2k views
in Education & Reference by

 

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?

 

1 Answer

0 like 0 dislike
by (850 points)

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.

Related questions

1 like 0 dislike
1 answer 55 views
0 like 0 dislike
2 answers 552 views
0 like 0 dislike
2 answers 159 views
0 like 0 dislike
0 answers 527 views
0 like 0 dislike
1 answer 54 views

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

...