Table ‘mysql.servers’ doesn’t exist

ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist
This appeared up on Server version: 5.1.57 when ever I'd run the FLUSH PRIVILEGES command from within mysql
To resolve this 


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' 


However a better way to solve this problem after carrying out an update is to run the mysql fix script mysql_fix_privilege_tables to ensure the ‘mysql’ database contains all the needed tables etc.

Comments

Popular posts from this blog

Basic Send Message to MQ with Java and IBM MQ JMS

Basic Receive Message to MQ with Java and IBM MQ JMS

Creating a simple Alert / Success Message with ASP.NET/VB using Bootstrap