Search code examples
mysqldatabasemysql-workbenchfederated

Enable Federated engine in MySQL 5.6 Windows

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

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..