Enable Federated engine in MySQL 5.6 Windows

database, federated, mysql, mysql-workbench

Solution

Correct edit, wrong file location.

The location for the configuration file for MySQL v5.6 with a default MySQL Installer installation on Windows 7 64-bit is:

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini

Not C:\Program Files..

Problem

I am trying to enable Federated engine in MySQL. I did followed some post and blogs and i edited my-default.ini [Location: C:\Program Files\MySQL\MySQL Server 5.6] by adding federated keyword under [mysqld]. ``` [mysqld] federated ``` Later i have restarted MySQL Server and i went to cross verify whether it is enabled or not by firing SQL Query show engines; ``` Engine Support Transactions XA Savepoints FEDERATED NO NULL NULL NULL ``` Can any one please help me. Environment Operating System : Windows 7 64bit MySQL Version : 5.6

Original source