FEDERATED未启动的问题

【Unknown storage engine 'FEDERATED'】解决办法

MYSQL配置文件my.ini里，[mysqld]下面加上federated，重启MYSQL服务

具体步骤如下

1、执行下面SQL，确认FEDERATED是否启动。

show engines;

执行结果：

ENGINE                                                           SUPPORT  COMMENT                                                                          TRANSACTIONS XA  SAVEPOINTS
---------------------------------------------------------------- -------- -------------------------------------------------------------------------------- ------------ --- ----------
InnoDB                                                           DEFAULT  Supports transactions, row-level locking, and foreign keys                       YES          YES YES       
MRG_MYISAM                                                       YES      Collection of identical MyISAM tables                                            NO           NO  NO        
MEMORY                                                           YES      Hash basSUPPORT ed, stored in memory, useful for temporary tables                        NO           NO  NO        
BLACKHOLE                                                        YES      /dev/null storage engine (anything you write to it disappears)                   NO           NO  NO        
MyISAM                                                           YES      MyISAM storage engine                                                            NO           NO  NO        
CSV                                                              YES      CSV storage engine                                                               NO           NO  NO        
ARCHIVE                                                          YES      Archive storage engine                                                           NO           NO  NO        
PERFORMANCE_SCHEMA                                               YES      Performance Schema                                                               NO           NO  NO        
FEDERATED                                                        YES      Federated MySQL storage engine                                                   NO           NO  NO        

如果【SUPPORT  】项是NO，表示是未启动状态。需要启动。

2、在控制面板》管理工具》服务里面找到MySQL的服务。

查看my.ini的路径。

my.ini里面【mysqld】下面加上federated，重启MySQL服务。

按第一步再次确认federated是否是开启状态。