mysql 에서 DB생성 및 권한부여를 하고 마지막에

flush privileges; 넣었는는데

ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist

에러 발생시..

 

- mysql 접속해서 붙여넣기

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

 

- 실제화면

mysql> 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';
Query OK, 0 rows affected (0.00 sec)

Posted by 모노 MonoMono


티스토리 툴바