MySQL 8.4 版本資訊
有幾種方法可以判斷伺服器中安裝了哪些外掛程式
Information Schema
PLUGINS
表格包含每個載入的外掛程式的列。任何具有PLUGIN_LIBRARY
值為NULL
的都是內建的,無法解除載入。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: 80100.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: mysql_native_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: Native MySQL authentication PLUGIN_LICENSE: GPL LOAD_OPTION: FORCE ...
SHOW PLUGINS
陳述式會顯示每個載入的外掛程式的列。任何具有Library
值為NULL
的都是內建的,無法解除載入。mysql> SHOW PLUGINS\G *************************** 1. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: mysql_native_password Status: ACTIVE Type: AUTHENTICATION Library: NULL License: GPL ...
mysql.plugin
表格顯示哪些外掛程式已使用INSTALL PLUGIN
註冊。表格僅包含外掛程式名稱和程式庫檔案名稱,因此它提供的資訊不如PLUGINS
表格或SHOW PLUGINS
陳述式。