mariadb-plugin is a tool for enabling or disabling plugins.
The client was previously called mysql_plugin, and can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.
It is a command line alternative to the INSTALL PLUGIN and UNINSTALL PLUGIN statements, and the --plugin-load option to mariadbd.
mariadb-plugin must be run while the server is offline, and works by adding or removing rows from the mysql.plugin table.
mariadb-plugin basically has two use cases:
To add a plugin even before the first real server startup.
To remove a plugin that crashes the server on startup.
For the installation use case, adding a entry to my.cnf or in a separate include option file is a better alternative. In case of a plugin loaded via a mysql.plugin crashing the server, uninstalling the plugin with the help of mariadb-plugin can be the only viable action, though.
mariadb-plugin expects to find a configuration file that indicates how to configure the plugins. The configuration file has, by default, the same name as the plugin, with an .ini extension:
Here, mariadb-plugin looks 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. The # character at the start of a 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.
This page is licensed: CC BY-SA / Gnu FDL
-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_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.
-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.
mariadb-plugin [options] <plugin> ENABLE|DISABLEmariadb-plugin crazyplugins ENABLEcrazyplugins
crazyplugin1
crazyplugin2
crazyplugin3