4月21
今天从MySQL5.0升级到MySQL5.1,创建数据库、帐号密码以后,执行flush privileges;,提示:
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
解决方法为,建立mysql.server表:
CREATE TABLE mysql.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=gbk[或utf8] COMMENT='MySQL Foreign Servers table';
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
解决方法为,建立mysql.server表:
CREATE TABLE mysql.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=gbk[或utf8] COMMENT='MySQL Foreign Servers table';
Shared objec
如何修改mysql数据文



