ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist

[mk6032]

Using fresh install CentOS 5.4 i386. I get to the mysql_secure_installation portion, and that line is returned. I am unable to continue past perl ispcp-setup.

[motokochan]

If you had MySQL installed and running on the server before running the install process, you need to make sure to run mysql_upgrade first. It'll create the new tables needed by the newer release of MySQL.

The install instructions don't cover it since they are for a base install (no checks in the roles shown in the installer).

[bashar]

I was having the same problem, I migrated ispcp 10.5 from debian 5 to ubuntu 10 (mysql 5.0.x versus 5.1.x) and the problem appeared when I tried to upgrade ispcp to 1.0.7 on ubuntu(it was using mysql db from debian ). After running

mysql_upgrade --force

everything was fine.