bitscn.com
解决table 'mysql.servers' doesn't exist今天遇到一事，就是我在升级mysql数据库后进入数据建立一远程用户，结果报错了。
mysql> flush privileges;error 1146 (42s02): table 'mysql.servers' doesn't exist
这是由于升级完数据库后丢失原有的系统表后造成的
解决方案：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'; query ok, 0 rows affected (0.05 sec)mysql> flush privileges;query ok, 0 rows affected (0.00 sec)mysql>
bitscn.com