UNINSTALL SONAME
Syntax
UNINSTALL SONAME [IF EXISTS] 'plugin_library'
Contents
Description
This statement is a variant of UNINSTALL PLUGIN statement, that removes all plugins belonging to a specified plugin_library. See UNINSTALL PLUGIN for details.
plugin_library is the name of the shared library that
contains the plugin code. The file name extension (for
example, libmyplugin.so or libmyplugin.dll) can be omitted (which makes the statement look the same on all architectures).
To use UNINSTALL SONAME, 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 library does not exist. See SHOW WARNINGS.
Examples
To uninstall the XtraDB plugin and all of its information_schema tables with one statement, use
UNINSTALL SONAME 'ha_xtradb';
From MariaDB 10.4.0:
UNINSTALL SONAME IF EXISTS 'ha_example'; Query OK, 0 rows affected (0.099 sec) UNINSTALL SONAME IF EXISTS 'ha_example'; Query OK, 0 rows affected, 1 warning (0.000 sec) SHOW WARNINGS; +-------+------+-------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------+ | Note | 1305 | SONAME ha_example.so does not exist | +-------+------+-------------------------------------+
