MySQL Plugin FEDERATED is disabled resolution

Contents

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.

Resolution

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

Federated

Verification

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.

Source(s)

https://www.diewufeiyang.com/post/951.html
http://www.robertopasini.com/index.php/2-uncategorised/700-mysql-risolvere-mysql-plugin-federated-is-disabled