Current time: 12-23-2024, 06:23 PM Hello There, Guest! (LoginRegister)


Post Reply 
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
Author Message
mk6032 Offline


Posts: 1
Joined: Jan 2010
Reputation: 0
Post: #1
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
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.
01-06-2010 02:36 AM
Find all posts by this user Quote this message in a reply
motokochan Offline
Member
***

Posts: 274
Joined: Jul 2008
Reputation: 1
Post: #2
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
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).
(This post was last modified: 01-06-2010 03:14 AM by motokochan.)
01-06-2010 03:13 AM
Visit this user's website Find all posts by this user Quote this message in a reply
bashar Offline
Newbie
*

Posts: 6
Joined: May 2008
Reputation: 0
Post: #3
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
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 Smile ). After running

mysql_upgrade --force

everything was fine.
01-18-2011 09:16 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 7 Guest(s)