지식
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist 발생시
두 아이 아빠
2014. 2. 27. 20:10
mysql 에서 flush privileges; 실행시 ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist 발생시
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=euckr COMMENT='MySQL Foreign Servers table';
입력하면 문제 해결됨.