4月21

MySQL执行flush privileges;出错

| |
02:55Database  
今天从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';

阅读(1053) | 评论(0) | 引用(0)