User Management Cannot Proceed Error

[Karen Goeller]

OK folks, I know I ran into this one time many moons ago, but I can't recall what the fix was or find any documentation on it.

When I click either “add user” or “edit user” in User Management, i get the following message:

SQLyog User Management cannot proceed because the 'user' table in the 'mysql' database does not contain the columns it should for this MySQL version.

Most likely the cause is that this version was installed 'on top' of a previous version without performing the steps necessary to complete the upgrade. Refer to the MySQL documentation for information on how to upgrade the MySQL server.

User Management will now exit.

When I go to Manage User Permissions, the grant tables display correctly, but if I try to save anything I get an error 1054, unknown column 'Create_view_priv' in field list.

I can, however, manually add and edit users and manage grants at the mysql command line. Our MySQL server is at 5.0.37 and I've upgraded to SQLyog 6.03 (today, which had no impact on the problem).

The last time this happened, I seem to remember that it actually didn't have anything to do with changes made to MySQL server.

Have any of you seen this and do you know what to do to fix it???

ALL help will be gratefully accepted!

Karen Goeller

Bucks County Community College

[email protected]

[peterlaursen]

The reason is that the curent Mysql server version has incorrectly been upgraded from a previous vesion!

When upgrading the MySQL server it is not sufficent to install the server binary 'on top of' the previous server version.  You must also update the mysql system tables by executing the update script or program provided by MySQL AB ('mysql_fix_privileges_tables'-sql or 'mysql_update' (depending on the mysql version upgraded to) for instance). 

Please refer to the mysql documentation for details (or ask here …)!

[Author]

Posts