mysqldatabase-performancefederated-storage-engine

How to enable FEDERATED engine in XAMPP

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.

Solution

  • 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