There are several ways to determine which plugins are installed in the server:
The Information Schema
PLUGINS
table contains a row for each loaded plugin. Any that have aPLUGIN_LIBRARY
value ofNULL
are built in and cannot be unloaded.mysql> TABLE INFORMATION_SCHEMA.PLUGINS\G *************************** 1. row *************************** PLUGIN_NAME: binlog PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 90100.0 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: Oracle Corporation PLUGIN_DESCRIPTION: This is a pseudo storage engine to represent the binlog in a transaction PLUGIN_LICENSE: GPL LOAD_OPTION: FORCE *************************** 2. row *************************** PLUGIN_NAME: sha256_password PLUGIN_VERSION: 1.1 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: AUTHENTICATION PLUGIN_TYPE_VERSION: 2.1 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: Oracle Corporation PLUGIN_DESCRIPTION: SHA256 password authentication PLUGIN_LICENSE: GPL LOAD_OPTION: FORCE ...
The
SHOW PLUGINS
statement displays a row for each loaded plugin. Any that have aLibrary
value ofNULL
are built in and cannot be unloaded.mysql> SHOW PLUGINS\G *************************** 1. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: sha256_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ...
The
mysql.plugin
table shows which plugins have been registered withINSTALL PLUGIN
. The table contains only plugin names and library file names, so it does not provide as much information as thePLUGINS
table or theSHOW PLUGINS
statement.