解决Table 'mysql.servers' doesn't exist
今天遇到一事,就是我在升级mysql数据库后进入数据建立一远程用户,结果报错了。
mysql> flush privileges;
ERROR (42S02): Table 'mysql.servers' doesn't exist
这是由于升级完数据库后丢失原有的系统表后造成的
解决方案:
mysql> CREATE TABLE `servers` (
-> `Server_name` char() NOT NULL,
-> `Host` char() NOT NULL,`Db` char() NOT NULL,
-> `Username` char() NOT NULL,
-> `Password` char() NOT NULL,
-> `Port` int() DEFAULT NULL,
-> `Socket` char() DEFAULT NULL,
-> `Wrapper` char() NOT NULL,
-> `Owner` char() NOT NULL,
-> PRIMARY KEY (`Server_name`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
Query OK, rows affected (0.05 sec) mysql> flush privileges;
Query OK, rows affected (0.00 sec) mysql>