[BlueOnyx:08096] Re: phpMyAdmin error with Privileges

[Michael Stauber]

Hi Jeff,

> Having an interesting issue with newly installed 5107R... cmuImported all
> sites from previous box (5106R) and imported the sqldump. Having troubles
> with the Wordpress sites that have databases and suphp. Went to the
> phpMyAdmin pages in the GUI and can't go to the Privileges tab to assign
> or view their privileges Get this error:
> 
> MySQL said:
> 
> #1054 - Unknown column 'Event_priv' in 'field list'
> 
> This is in ALL databases, system generated and imported by me. Anyone else
> having this issue?

Not entirely sure, but I'd try this from SSH:

mysql_fix_privilege_tables <mysql-root-password>

So if the MySQL root password is "supersecret", the command would be:

mysql_fix_privilege_tables supersecret

That command handles privilege table conversions when you imported  a dump 
from an older MySQL database server.

-- 
With best regards

Michael Stauber