1.修改my.ini,增加federated,重启数据库;
2.查询数据库:SHOW ENGINES;
FEDERATED support yes;
3.创建表映射:
CREATE TABLE IF NOT EXISTS `user` (
`id` INT(11) DEFAULT NULL,
`name` VARCHAR(20) DEFAULT NULL
)ENGINE =FEDERATED CONNECTION='mysql://root:root@远端数据库ip:3306/数据库名/表名';