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
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.
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
Post a Comment