title: cannot install plugin federated in xampp phpmyadmin
body: <p>I want to create a table with a federated engine so that everytime there is a data change in the server1 table, change data in server2 will also take effect.</p>
  
  <p>Unfortunately when I try to create a table with federated engine this was the error <code>#1286 - Unknown storage engine 'FEDERATED'</code></p>
  
  <p>I search as many as I can on how to install or enable <strong>Federated</strong> storage engine in phpmyadmin xampp but to no avail I did not find a solution.</p>
  
  <p>I need to have a Federated storage engine in my xampp
  [<a href="https://i.stack.imgur.com/cG8VO.png" rel="nofollow noreferrer">List of storage engine available in my phpmyadmin</a>
  ]</p>
  
  <p>These are the solutions I searched but did not worked for me</p>
  
  <ol>
  <li>Put "federated" in the my.ini file under the [mysqld] </li>
  <li>Downloaded ha_federated.dll located at C:\xampp\mysql\lib\plugin\</li>
  <li>Install plugin federated soname 'ha_federated.so'
  
  <ul>
  <li>'ha_federated.dll'</li>
  <li>'ha_federatedx.dll'</li>
  <li>'ha_federatedx.so'
  
  <ul>
  <li>All same errors <code>#1126 - Can't open shared library 'C:\xampp\mysql\lib\plugin\ha_federated.dll' (errno: 2, The specified module could not be found.)</code></li>
  </ul></li>
  </ul></li>
  </ol>
  
  <p>Does anyone know the solution to this problem I'm encountering? </p>
  
  <p>UPDATE</p>
  
  <p>MySQL returned an empty result set </p>
  
  <blockquote>
    <p>select * from information_schema.engines where engine="federated" </p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/gW2V4.png" rel="nofollow noreferrer">Query Result</a></p>