Skip navigation links

MySQL Forums :: Install :: Table 'mysql.servers' doesn't exist


Advanced Search

Re: Table 'mysql.servers' doesn't exist
Posted by: Chris Brown ()
Date: July 02, 2007 08:17PM

This should solve the problem. Not sure how this problem started for me but I mysqldumped the mysql.server table from another database and eliminated the error.

Best,
C



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';

Options: ReplyQuote


Subject Written By Posted
Table 'mysql.servers' doesn't exist Lars Andersen 03/04/2007 06:47PM
Re: Table 'mysql.servers' doesn't exist Lars Andersen 03/05/2007 07:35AM
Re: Table 'mysql.servers' doesn't exist Tarang Pandya 04/14/2007 12:05AM
Re: Table 'mysql.servers' doesn't exist Lars Andersen 05/05/2007 05:55PM
Re: Table 'mysql.servers' doesn't exist Chris Brown 07/02/2007 08:17PM
Re: Table 'mysql.servers' doesn't exist GLEN GRANT 12/18/2007 11:57AM
Re: Table 'mysql.servers' doesn't exist Thomas CORBIERE 07/03/2007 12:40AM
Re: Table 'mysql.servers' doesn't exist Eugeny Kuzmenko 10/29/2007 04:05AM
Re: Table 'mysql.servers' doesn't exist Bodo Barwich 02/11/2009 07:46AM


Sorry, you can't reply to this topic. It has been closed.