DB Error when trying to use phpMyAdmin from SiteWorx

I (and my users) receive the following error when trying to use the phpMyAdmin link within any SiteWorx accounts on my server:

DB Error: no such table FLUSH PRIVILEGES [nativecode=1146 ** Table 'mysql.servers' doesn't exist]

The error doesn’t happen when using phpMyAdmin from NodeWorx though.

Any ideas?

I believe the most likely explaination is that the MySQL server was upgraded, but the mysql_upgrade script wasn’t run afterwards.

Try running it with

% mysql_upgrade -u root -p
and enter your mysql root password


That fixed it, many thanks Paul :smiley:


Just an update: this also works with the iworx user