How to enable FEDERATED engine in XAMPP

5.9k Views Asked by At

How can I enable the FEDERATED storage engine in the MySQL that comes with XAMPP distribution? I am using Version 1.8.3 of XAMPP with MySQL Version 5.6.16-log.

The INFORMATION_SCHEMA.ENGINES table shows that FEDERATED support is NO.

1

There are 1 best solutions below

2
On BEST ANSWER

In my.ini or my.cnf you should deactivate the option

skip-federated

For my my.ini I had to change:

# commented in by lampp security
# skip-networking
skip-federated

to

# commented in by lampp security
# skip-networking
# skip-federated