MySQL执行语句Table‘mysql.servers‘doesn‘texist

执行语句报错：

mysql> flush privileges; ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist

解决：

进入数据库

删除servers表

mysql> use mysql Database changed mysql> drop table if exists servers; Query OK, 0 rows affected, 1 warning (0.60 sec)

手动创建：

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;

ok了

mysql> flush privileges; Query OK, 0 rows affected (4.38 sec)