MySQL Error number: MY-010747; Symbol: ER_PLUGIN_DISABLED; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-010747; Symbol: ER_PLUGIN_DISABLED; SQLSTATE: HY000

Message: Plugin ‘%s’ is disabled.

Error MY-010747: ER_PLUGIN_DISABLED

Description:

MySQL error MY-010747 occurs when an attempt is made to use a disabled plugin. When this error is thrown, the user receives the following message: “Plugin is disabled”, with “” being the name of the respective disabled plugin.

Common Cases:

This error can occur when attempting to use a disabled plugin. This can be the result of MySQL settings, or of manually disabling the plugin. This can be further caused by trying to run a query on a server running a version of MySQL that does not have the plugin.

Resolution:

The first step to resolving this error is to make sure it is the correct plugin being used by the mysql server. To check this, run the “show plugins” command which will list any enabled and disabled plugins. If your desired plugin is listed but is listed as disabled, then it should be enabled by running the “enable plugin ” command where “” is the name of the plugin.

Further, if the plugin is listed as disabled but you do not want to enable it, you should connect to a server that does have the plugin enabled.

Finally, if the plugin is not available at all, you should ensure that the version of MySQL being run is compatible with the plugin you are attempting to use. If not, you should upgrade the MySQL version being run to one that is compatible.