EC
1531
MySQLERRORNotableServerHIGH confidence

Plugin is not loaded

Production Risk

Medium — the statement requiring the plugin will fail.

What this means

ER_PLUGIN_IS_NOT_LOADED (1531, SQLSTATE HY000) is raised when a statement references a plugin (such as a storage engine or authentication plugin) that has not been loaded.

Why it happens
  1. 1Using a storage engine whose plugin is not installed
  2. 2Authentication plugin referenced in CREATE USER not loaded
  3. 3Plugin was uninstalled or failed to load at startup
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (id INT) ENGINE=Spider;
-- If Spider plugin is not loaded

expected output

ERROR 1531 (HY000): Plugin 'Spider' is not loaded

Fix

Install or load the required plugin

Install or load the required plugin
-- Check loaded plugins:
SHOW PLUGINS;

-- Install a plugin:
INSTALL PLUGIN spider SONAME 'ha_spider.so';

-- Or enable in my.cnf:
-- plugin-load-add=ha_spider.so

Why this works

The plugin must be installed and loaded before it can be used.

Sources
Official documentation ↗

MySQL 8.0 — 1531 ER_PLUGIN_IS_NOT_LOADED

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors