<p>MySQL cannot find or start the named plugin, so the requested statement fails.</p>
<p>MySQL Error 1524: ER_PLUGIN_IS_NOT_LOADED occurs when the server cannot locate or initialize the requested plugin. Check plugin installation, configuration, and the plugin_dir path, then INSTALL or INSTALL SONAME the module to resolve the issue.</p>
Plugin '%s' is not loaded
Error 1524, ER_PLUGIN_IS_NOT_LOADED, is raised when MySQL executes a statement that depends on a server plugin that is not currently loaded or cannot be located in the plugin_dir directory.
The error halts the statement because the requested authentication, storage, or auditing feature cannot run without its binary or configuration.
Unloaded plugins break critical features such as user authentication, log auditing, or data compression. Production outages, login failures, and replication stops often follow, so resolving the error quickly is essential.
The plugin shared library (.so or .dll) may be missing from the plugin_dir path set in my.cnf.
The plugin might be compiled for a different MySQL version or architecture, preventing initialization.
A failed INSTALL PLUGIN or missing INSTALL SONAME statement leaves metadata but not the binary, triggering the error on use.
Server upgrades that overwrite or relocate plugin files also lead to Error 1524.
Verify plugin_dir and ensure the plugin library file exists with correct permissions.
Reinstall or copy the plugin file, then execute INSTALL PLUGIN or INSTALL SONAME to register it.
If the plugin is no longer needed, uninstall it with UNINSTALL PLUGIN to stop MySQL from searching for it.
Authentication plugins like auth_socket often trigger Error 1524 when users are created with a missing plugin. Reinstall the plugin package or change user authentication to a loaded plugin.
Replication fails when rpl_semi_sync_master isn’t loaded. Install the plugin or disable semisync in my.cnf and restart.
Package plugins with configuration management tools so version upgrades keep binaries in sync.
Use SHOW PLUGINS after upgrades to verify all REQUIRED plugins are ACTIVE.
Store plugin binaries in a shared, backed-up path and set plugin_dir consistently across nodes.
Error 1538 ER_LOAD_FROM_TABLE_FAILED appears when INSTALL PLUGIN cannot read the plugin's .frm metadata.
Error 1146 ER_NO_SUCH_TABLE may surface if a storage engine plugin fails to load and its system tables are inaccessible.
The shared object (.so/.dll) is absent from plugin_dir, often after manual cleanup or incomplete upgrade.
my.cnf points to a directory that does not contain the plugin binaries.
A plugin compiled for a different MySQL version cannot initialize and remains unloaded.
File permissions or disk corruption prevents the server from reading the library.
Raised when INSTALL PLUGIN cannot read the plugin table.
May appear when authentication plugins are missing, blocking login.
Occurs if a storage engine plugin fails and system tables disappear.
The server error log lists the plugin name. SHOW PLUGINS shows a status of 'NOT INSTALLED' or 'DISABLED' for that plugin.
Yes. INSTALL PLUGIN or INSTALL SONAME loads a plugin at runtime. Persist by adding it to my.cnf.
Only if no users or features depend on it. Check mysql.user and system variables first.
Galaxy surfaces server errors immediately in its editor sidebar and offers AI guides to run SHOW PLUGINS and INSTALL statements, reducing resolution time.
.avif)
.avif){kind=logo}
