MySQL Plugin FEDERATED is disabled resolution

MySQL 5.6.xx  logs may contain a “Note” message that the “Plugin ‘FEDERATED’ is disabled.” The plugin has been available since MySQL 5.0.3 and is a storage engine that accesses data in tables of remote databases rather than local tables. There is a resolution to this.

Log Entries

2019-11-12 21:52:18 2338 [Note] Plugin 'FEDERATED' is disabled.


Then edit the my.cnf to add the following line under the [mysql] section.



Restart the mysql daemon and review the log file to determine the level of success.  There should be no more reference in the log files.

Further, log into MySQL and use show engines; to see that FEDERATED is now supported.