MySQL 8 Administrator???s Guide

Getting information about the installed plugins

There are multiple ways to get information about the installed plugins. Some of them are listed as follows, for your reference:

• The INFORMATION_SCHEMA.PLUGINS table contains plugin details such as PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, and many more. Each individual row of this table represents information about the plugin:

        SELECT * FROM information_schema.PLUGINS;

• The SHOW PLUGINS statement shows the name, status, type, library, and license details for each of the individual plugins. If the library value is NULL, it indicates that it is a built-in plugin and hence, it cannot be unloaded.

        SHOW PLUGINS;

• The mysql.plugin table contains details regarding ...