Hi!请登陆

解决Table 'mysql.servers' doesn't exist

2020-10-27 59 10/27

第一个试过可以:

使用MySQL Query Browser为mysql库创建缺失的表.
系统数据库(mysql) 缺少表的创建sql命令为:

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';

另外一种解决办法是:进入Mysql的bin目录运行:

mysql -u root -p mysql

输入密码后运行:

mysql> SOURCE ../share/mysql_fix_privilege_tables.sql
Tag:

相关推荐