content_image/853619.jpg content_image/853614.jpg
To install the ddl_rewriter  plugin, use the INSTALL PLUGIN  statement, adjusting the .so  suffix for your platform as necessary: 

INSTALL PLUGIN ddl_rewriter SONAME ’ddl_rewriter.so’; 

To verify plugin installation, examine the INFORMATION_SCHEMA.PLUGINS  table or use the SHOW PLUGINS  statement (see Section 5.6.2, “Obtaining Server Plugin Information” ). For example: 

mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ’ddl%’; 

<img src='content_image/853619.jpg'>

As the preceding result shows, ddl_rewriter  is implemented as an audit plugin. 

If the plugin fails to initialize, check the server error log for diagnostic messages. 

Once installed as just described, ddl_rewriter  remains installed until uninstalled. To remove it, use UNINSTALL PLUGIN : 

UNINSTALL PLUGIN ddl_rewriter; 

If ddl_rewriter  is installed, you can use the --ddl-rewriter  option for subsequent server startups to control ddl_rewriter  plugin activation. For example, to prevent the plugin from being enabled at runtime, use this option: 

## 5.6.5.2 ddl_rewriter Plugin Options 

[mysqld] ddl-rewriter=OFF 

This section describes the command options that control operation of the ddl_rewriter  plugin. If values specified at startup time are incorrect, the ddl_rewriter  plugin may fail to initialize properly and the server does not load it. 

To control activation of the ddl_rewriter  plugin, use this option: 

• --ddl-rewriter[= value ] 

<img src='content_image/853614.jpg'>

This option controls how the server loads the ddl_rewriter  plugin at startup. It is available only if the plugin has been previously registered with INSTALL PLUGIN  or is loaded with --plugin-load  or -- plugin-load-add . See Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter” . 

