Thursday, April 15, 2010

MySQL_Upgrade MySQL_Check fix for "column count of mysql.proc is wrong"

from command prompt: (remember to have NO space between '-p' and '[password]')

C:>mysql_check -u [user] -p[password] --repair --all-databases

This will repair your databases. This does not work on InnoDB.

C:>mysql_upgrade -u [user] -p[password] --all-databases

This will upgrade your databases.

This fixes the 'column count of mysql.proc is wrong' error when using MySQL Workbench on a databases that has been created with MySQL Server earlier than 5.2

No comments:

Post a Comment