PDA

View Full Version : DB Error when trying to use phpMyAdmin from SiteWorx


Fr3d
08-07-2010, 06:44 PM
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?

IWorx-Paul
08-07-2010, 07:46 PM
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

Paul

Fr3d
08-07-2010, 07:51 PM
That fixed it, many thanks Paul :D