Error: User Management Cannot Proceed – Help?

[Karen Goeller]

I had previously been able to successfully add, edit, and manage users through User Management. Suddenly, I'm unable to add or edit, but can still manage users. We're on MySQL 4.0.20-standard on Linux and SQLyog Enterprize v5.22 on Win XP.

The error I receive when I try to add or edit users is:

—-

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

Most likely the reason fo rthis is that the current MySQL Server version was installed 'on top' of a previous version without performing the steps necessary to complete the upgrad.e Refer to the MySQL documentation on how to upgrade the MySQL server.

User Management will now exit.

—-

However, the standard add user or edit user queries work just fine on the database when run at the command line.

The MySQL server has not been updated or changed in quite a while. I've run the Extended Check and Analyze table diagnostics on the entire mysql database (and the user table separately) and am not receiving any reported errors.

The fields in the mysql.user table are:

Host

User

Password

Select_priv

Insert_priv

Update_priv

Delete_priv

Create_priv

Drop_priv

Reload_priv

Shutdown_priv

Process_priv

File_priv

Grant_priv

References_priv

Index_priv

Alter_priv

I'm now out of ideas as to where to look to resolve the problem. Given that the user add/update queries work at the command line, this seems to me to point to an issue within SQLyog… Any help will be greatly appreciated!

Thanks!

[peterlaursen]

And ist should be (for a 4.0.x server) like this:

Select_priv

Insert_priv

Update_priv

Delete_priv

Create_priv

Drop_priv

Reload_priv

Shutdown_priv

Process_priv

File_priv

Grant_priv

References_priv

Index_priv

Alter_priv

Show_db_priv

Super_priv

Create_tmp_table_priv

Lock_tables_priv

Execute_priv

Repl_slave_priv

Repl_client_priv

ssl_type

ssl_cipher

x509_issuer

x509_subject

max_questions

max_updates

max_connections

As I wrote in your ticket you should run the fix-privileges script.

Looks like this server has been (incorrectly) upgraded form 3.23.x

[Author]

Posts