#1146 Table 'mysql.server' doesn't exist가 없어서 에러발생하였습니다.


원인을 찾았으니 간단하게 생성해주면 됩니다.



CREATE TABLE `servers` (

`Server_name` CHAR(64) NOT NULL DEFAULT '',

`Host` CHAR(64) NOT NULL DEFAULT '',

`Db` CHAR(64) NOT NULL DEFAULT '',

`Username` CHAR(64) NOT NULL DEFAULT '',

`Password` CHAR(64) NOT NULL DEFAULT '',

`Port` INT(4) NOT NULL DEFAULT '0',

`Socket` CHAR(64) NOT NULL DEFAULT '',

`Wrapper` CHAR(64) NOT NULL DEFAULT '',

`Owner` CHAR(64) NOT NULL DEFAULT '',

PRIMARY KEY (`Server_name`)

)

COMMENT='MySQL Foreign Servers table'

COLLATE='utf8_general_ci'

ENGINE=MyISAM

;




+ Recent posts