MySQL - UNINSTALL PLUGIN Statement

In addition to existing server components, you can create a new required component in the server using the plugin API supported by the server. Using this API, you can install additional softwares such as storage engines, full-text parser plugins, and server extensions. You can install a MySQL plugin in MySQL using the INSTALL PLUGIN Statement.

MySQL UNINSTALL PLUGIN Statement

You can remove/uninstall an installed plugin using the UNINSTALL PLUGIN Statement. To execute this statement, you need DELETE privilege.

Syntax

Following is the syntax of the MySQL UNINSTALL PLUGIN statement −

UNINSTALL PLUGIN plugin_name

Where, plugin_name is the name of the plugin you need to uninstall.

Example

Assume we have installed a clone plugin using the INSTALL PLUGIN statement as shown below −

INSTALL PLUGIN clone SONAME 'mysql_clone.dll';

After installing the plugin, you can verify the its details as shown below −

SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'clone%';

Output

Following is the output of the above query −

Following query removes the clone plugin installed above −

UNINSTALL PLUGIN clone;

Since we have uninstalled the clone plugin If you execute the above SELECT query again you will get an empty set −

SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'clone%';
Empty set (0.00 sec)

Example

Let us install two more plugins in MySQL using the INSTALL PLUGIN statement −

Install plugin validate_password soname 'validate_password.dll';
Install plugin mysql_no_login soname 'mysql_no_login.dll';

Following queries uninstalls the above installed plugins −

Uninstall plugin validate_password;
Uninstall plugin mysql_no_login;