UNINSTALL SONAME

Uninstall all plugins loaded from a specific library. This statement removes every plugin associated with the library file and unloads the library itself.

Syntax

UNINSTALL SONAME  [IF EXISTS] 'plugin_library'

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 thatcontains the plugin code. The file name extension (forexample, 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.

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';

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 |
+-------+------+-------------------------------------+

See Also

• INSTALL SONAME

• SHOW PLUGINS

• INSTALL PLUGIN

• UNINSTALL PLUGIN

• SHOW PLUGINS

• INFORMATION_SCHEMA.PLUGINS Table

• mysql_plugin

• List of Plugins

_{This page is licensed: CC BY-SA / Gnu FDL}