Install MySQL FEDERATED engine

 Install MySQL FEDERATED engine

Menambahkan/Aktifkan Engines FEDERATED pada XAMPP

1.Download MariaDB versi 10.6.xx dan extract letak kan di dalam folder xampp
2.Masuk ke folder Xampp dan ubah folder mysql jadi mysql.old
3.Hasil extract MariaDB ubah menjadi mysql
4.Masuk ke folder mysql.old, copy backup,script,mysql_installservice.bat,mysql_uninstallservice.bat
5.Paste kan file tsb ke dalam folder mysql yg baru
6.Buka CMD arahkan ke tempat menginstall xampp
  etc : C:\xampp\mysql>mysql -u root -p
             Enter password: *****(password database)
  bila error set path : C:\xampp\mysql>set path=%PATH%;C:\xampp\mysql\bin;
7.Install plugin federated
  MariaDB [(none)]> INSTALL PLUGIN federated SONAME 'ha_federatedx.so';
  ERROR 1126 (HY000): Can't open shared library 'C:\xampp\mysql\lib\plugin\ha_federatedx.so.dll'        (errno: 2, The specified module could not be found. )

 
  MariaDB [(none)]> INSTALL PLUGIN federated SONAME 'ha_federatedx.dll';
  Query OK, 0 rows affected (0.031 sec)

  MariaDB [(none)]> show engines;