📋

Description

This error indicates that MySQL attempted to load or utilize a specific plugin, but the plugin's shared library file was either missing, incorrectly configured, or inaccessible. It commonly occurs when a feature requiring a particular plugin is invoked, but the plugin itself is not properly installed or enabled within the MySQL server environment.

💬

Error Message

Plugin '%s' is not loaded

🔍

Known Causes

4 known causes

⚠️

Missing Plugin File

The required plugin's shared library file (.so or .dll) is not found in the designated MySQL plugin directory or the configured path.

⚠️

Incorrect Configuration

The MySQL server configuration (e.g., in `my.cnf` or `my.ini`) specifies a plugin that is misspelled, or the `plugin_dir` variable is pointing to an incorrect location.

⚠️

Insufficient Permissions

The MySQL server process lacks the necessary read permissions for the plugin file or its containing directory, preventing it from being loaded.

⚠️

Version Incompatibility

The plugin file exists but is compiled for a different MySQL version or architecture, making it incompatible with the running server instance.

🛠️

Solutions

3 solutions available

1. Verify Plugin Installation and Loading easy

Ensure the plugin is correctly installed and enabled in the MySQL configuration.

1

Connect to your MySQL server as a user with sufficient privileges (e.g., root).

2

Check if the plugin is loaded by running the following SQL query. Replace `%s` with the actual plugin name mentioned in the error message.

SHOW PLUGINS;

3

If the plugin is not listed or its status is 'DISABLED', you need to enable it. This often involves modifying your MySQL configuration file (`my.cnf` or `my.ini`). Locate the `[mysqld]` section and add or uncomment the `plugin-load` directive, specifying the plugin's shared library file. The exact file name will depend on the plugin and your operating system.

# Example for a hypothetical plugin 'myplugin' on Linux
# plugin-load = "myplugin=myplugin.so"

# Example for a hypothetical plugin 'myplugin' on Windows
# plugin-load = "myplugin=myplugin.dll"

4

After modifying the configuration file, restart your MySQL server for the changes to take effect.

# On Linux systems using systemd:
sudo systemctl restart mysql

# On Linux systems using init.d:
sudo service mysql restart

# On Windows (using Services GUI):
# Open services.msc, find your MySQL service, and restart it.

5

Re-run the `SHOW PLUGINS;` query to confirm the plugin is now loaded and active.

SHOW PLUGINS;

2. Install or Reinstall the Plugin medium

If the plugin files are missing or corrupted, reinstalling them can resolve the issue.

1

Identify the plugin that is failing to load from the error message (`%s`).

2

Consult the documentation for the specific plugin you are trying to use. This will guide you on how to install or reinstall it. This typically involves obtaining the plugin's shared library file (e.g., `.so` on Linux, `.dll` on Windows) and placing it in the MySQL plugin directory.

3

Determine the MySQL plugin directory. You can find this by running the following SQL query:

SHOW VARIABLES LIKE 'plugin_dir';

4

Copy the plugin's shared library file into the directory identified in the previous step.

5

Ensure the plugin is enabled in your MySQL configuration file as described in the 'Verify Plugin Installation and Loading' solution (Step 3).

6

Restart the MySQL server.

# On Linux systems using systemd:
sudo systemctl restart mysql

# On Linux systems using init.d:
sudo service mysql restart

3. Check File Permissions for Plugin Libraries medium

Ensure the MySQL server process has read and execute permissions on the plugin library files.

1

Identify the plugin that is failing to load from the error message (`%s`).

2

Locate the plugin's shared library file (e.g., `plugin_name.so` or `plugin_name.dll`) in the MySQL plugin directory (obtained via `SHOW VARIABLES LIKE 'plugin_dir';`).

3

Determine the user that the MySQL server process runs as. On most Linux systems, this is `mysql`.

4

Check the file permissions of the plugin library. You can use `ls -l` on Linux to view them.

# Example: ls -l /usr/lib/mysql/plugin/myplugin.so

5

Ensure the MySQL user has read and execute permissions on the plugin library file. If not, use `chmod` to grant them. Replace `plugin_name.so` with your actual plugin file name.

# On Linux, to grant read and execute to the owner and group:
# sudo chmod 755 /path/to/your/plugin_dir/plugin_name.so

# If the mysql user is in a specific group, ensure that group has permissions:
# sudo chgrp mysql /path/to/your/plugin_dir/plugin_name.so
# sudo chmod 755 /path/to/your/plugin_dir/plugin_name.so

6