server also enables the plugin. This can be changed with the -- plugin_name [= activation_state ] option. 

The --plugin-load  and --plugin-load-add  options load plugins after built-in plugins and storage engines have initialized during the server startup sequence. The --early-plugin-load  option is used to load plugins that must be available prior to initialization of built-in plugins and storage engines. 

The value of each plugin-loading option is a semicolon-separated list of plugin_library  and name = plugin_library  values. Each plugin_library  is the name of a library file that contains plugin code, and each name  is the name of a plugin to load. If a plugin library is named without any preceding plugin name, the server loads all plugins in the library. With a preceding plugin name, the server loads only the named plugin from the libary. The server looks for plugin library files in the directory named by the plugin_dir  system variable. 

Plugin-loading options do not register any plugin in the mysql.plugin  table. For subsequent restarts, the server loads the plugin again only if --plugin-load , --plugin-load-add , or --early-plugin- load  is given again. That is, the option produces a one-time plugin-installation operation that persists for a single server invocation. 

--plugin-load , --plugin-load-add , and --early-plugin-load  enable plugins to be loaded even when --skip-grant-tables  is given (which causes the server to ignore the mysql.plugin table). --plugin-load , --plugin-load-add , and --early-plugin-load  also enable plugins to be loaded at startup that cannot be loaded at runtime. 

The --plugin-load-add  option complements the --plugin-load  option: 

•Each instance of --plugin-load  resets the set of plugins to load at startup, whereas --plugin- load-add  adds a plugin or plugins to the set of plugins to be loaded without resetting the current set. Consequently, if multiple instances of --plugin-load  are specified, only the last one applies. With multiple instances of --plugin-load-add , all of them apply. 

•The argument format is the same as for --plugin-load , but multiple instances of --plugin-load- add  can be used to avoid specifying a large set of plugins as a single long unwieldy --plugin-load argument. 

• --plugin-load-add  can be given in the absence of --plugin-load , but any instance of -- plugin-load-add  that appears before --plugin-load  has no effect because --plugin-load resets the set of plugins to load. 

For example, these options: 

--plugin-load=x --plugin-load-add=y 

are equivalent to these options: 

--plugin-load-add=x --plugin-load-add=y 

and are also equivalent to this option: 

--plugin-load="x;y" 

But these options: 

--plugin-load-add=y --plugin-load=x 

are equivalent to this option: 

