Current time: 11-23-2024, 04:52 AM Hello There, Guest! (LoginRegister)


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

Posts: 8
Joined: Jan 2011
Reputation: 0
Post: #6
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
same error with same version of CentOS here, any update?
Here is the solution,

log into your mysql server, and run:

use mysql;

CREATE TABLE `servers` (
`Server_name` char (64) NOT NULL,
`Host` char (64) NOT NULL,
`Db` char (64) NOT NULL,
`Username` char (64) NOT NULL,
`Password` char (64) NOT NULL,
`Port` int (4) DEFAULT NULL,
`Socket` char (64) DEFAULT NULL,
`Wrapper` char (64) NOT NULL,
`Owner` char (64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'MySQL Foreign Servers table';
(This post was last modified: 02-02-2011 12:27 PM by mkreder.)
02-02-2011 12:19 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - mkreder - 02-02-2011 12:19 PM

Forum Jump:


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