UNINSTALL PLUGIN
Syntax
UNINSTALL PLUGIN [IF EXISTS] plugin_name
Contents
Description
This statement removes a single installed plugin. To uninstall the whole library which contains the plugin, use UNINSTALL SONAME. You cannot uninstall a plugin if any table that uses it is open.
plugin_name
must be the name of some plugin that is listed
in the mysql.plugin table. The server executes the plugin's deinitialization
function and removes the row for the plugin from the mysql.plugin
table, so that subsequent server restarts will not load and initialize
the plugin. UNINSTALL PLUGIN
does not remove the plugin's
shared library file.
To use UNINSTALL PLUGIN
, you must have the
DELETE privilege for the mysql.plugin table.
MariaDB starting with 10.4.0
IF EXISTS
If the IF EXISTS
clause is used, MariaDB will return a note instead of an error if the plugin does not exist. See SHOW WARNINGS.
Examples
UNINSTALL PLUGIN example;
From MariaDB 10.4.0:
UNINSTALL PLUGIN IF EXISTS example; Query OK, 0 rows affected (0.099 sec) UNINSTALL PLUGIN IF EXISTS example; Query OK, 0 rows affected, 1 warning (0.000 sec) SHOW WARNINGS; +-------+------+-------------------------------+ | Level | Code | Message | +-------+------+-------------------------------+ | Note | 1305 | PLUGIN example does not exist | +-------+------+-------------------------------+