yuandan 发表于 2018-9-30 07:36:05

mysql报错的“Table 'mysql.servers' doesn't exist”的解决方法

  原文:http://www.weiruoyu.cn/?p=571
  刷新时提示错误
  mysql> flush privileges;
  ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
  解决方法一,自己建立这张表。
  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;
参考:http://blog.csdn.net/kanon_lgt/article/details/5372520
页: [1]
查看完整版本: mysql报错的“Table 'mysql.servers' doesn't exist”的解决方法