断奶

成功了,宝贝加油哦!

ERROR 1146: Table ‘mysql.servers’ doesn’t exist

ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist 的解决办法

  1. mysql> flush privileges;
  2. ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
  3.  
  4.  
  5.  
  6. mysql> USE mysql;
  7.  
  8.  
  9.  
  10. mysql> CREATE TABLE `servers` (
  11.     -> `Server_name` CHAR(64) NOT NULL,
  12.     -> `Host` CHAR(64) NOT NULL,
  13.     -> `Db` CHAR(64) NOT NULL,
  14.     -> `Username` CHAR(64) NOT NULL,
  15.     -> `Password` CHAR(64) NOT NULL,
  16.     -> `Port` INT(4) DEFAULT NULL,
  17.     -> `Socket` CHAR(64) DEFAULT NULL,
  18.     -> `Wrapper` CHAR(64) NOT NULL,
  19.     -> `Owner` CHAR(64) NOT NULL,
  20.     -> PRIMARY KEY (`Server_name`)
  21.     -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
  22. Query OK, 0 rows affected (0.01 sec)
  23.  
  24. mysql> flush privileges;
  25. Query OK, 0 rows affected (0.00 sec)
1 1