The ddl_rewriter Plugin To install the  ddl_rewriter  plugin, use the  INSTALL PLUGIN  statement, adjusting the  .so  suffix for your platform as necessary: 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: INSTALL PLUGIN ddl_rewriter SONAME ’ddl_rewriter.so’; 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: 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: 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” . 1097 Command-Line Format --ddl-rewriter[=value] Introduced 8.0.16 Type Enumeration Default Value ON Valid Values ON OFF FORCE FORCE_PLUS_PERMANENT • --ddl-rewriter[= value ] 5.6.5.2 ddl_rewriter Plugin Options [mysqld] ddl-rewriter=OFF mysql>  SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ’ddl%’; +--------------+---------------+-------------+ | PLUGIN_NAME | PLUGIN_STATUS | PLUGIN_TYPE | +--------------+---------------+-------------+ | ddl_rewriter | ACTIVE | AUDIT | +--------------+---------------+-------------+