mysql_plugin is a tool for enabling or disabling plugins.

It is a commandline alternative to the INSTALL PLUGIN and UNINSTALL PLUGIN statements, and the --plugin-load option to mysqld.

mysql_plugin must be run while the server is offline, and works by adding or removing rows from the mysql.plugin table.

From MariaDB 10.4.6, mariadb-plugin is a symlink to mysql_plugin.


mysql_plugin [options] <plugin> ENABLE|DISABLE

mysql_plugin expects to find a configuration file that indicates how to configure the plugins. The configuration file is by default the same name as the plugin, with a .ini extension. For example:

mysql_plugin crazyplugins ENABLE

Here, mysql_plugin will look for a file called crazyplugins.ini


The first line should contain the name of the library object file, with no extension. The other lines list the names of the components. Each value should be on a separate line, and the # character at the start of the line indicates a comment.


The following options can be specified on the command line, while some can be specified in the [mysqld] group of any option file. For options specified in a [mysqld] group, only the --basedir, --datadir, and --plugin-dir options can be used - the rest are ignored.

Option Description
-b, --basedir=name The base directory for the server.
-d, --datadir=name The data directory for the server.
-?, --help Display help and exit.
-f, --my-print-defaults=name Path to my_print_defaults executable. Example: /source/temp11/extra
-m, --mysqld=name Path to mysqld executable. Example: /sbin/temp1/mysql/bin
-n, --no-defaults Do not read values from configuration file.
-p, --plugin-dir=name The plugin directory for the server.
-i, --plugin-ini=name Read plugin information from configuration file specified instead of from <plugin-dir>/<plugin_name>.ini.
-P, --print-defaults Show default values from configuration file.
-v, --verbose More verbose output; you can use this multiple times to get even more verbose output.
-V, --version Output version information and exit.

See Also

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.