Common SQL Errors

MySQL Error 1619: ER_PLUGIN_DELETE_BUILTIN - How to Fix and Prevent

Galaxy Team
August 7, 2025

<p>MySQL raises error 1619 when you try to uninstall or delete a plugin that is compiled into the server binary.</p>

Sign up for the latest in common SQL errors from the Galaxy Team!
Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)
Oops! Something went wrong while submitting the form.

What is MySQL error 1619 ER_PLUGIN_DELETE_BUILTIN?

<p>MySQL Error 1619: ER_PLUGIN_DELETE_BUILTIN occurs when an UNINSTALL PLUGIN command targets a built-in component. Skip the uninstall and, if needed, disable the feature via configuration to resolve the issue.</p>

Error Highlights

Typical Error Message

Built-in plugins cannot be deleted

Error Type

Plugin Error

Language

MySQL

Symbol

ER_PLUGIN_DELETE_BUILTIN

Error Code

1619

SQL State

HY000

Explanation

Table of Contents

What is MySQL Error 1619 ER_PLUGIN_DELETE_BUILTIN?

MySQL raises error 1619 (SQLSTATE HY000) with the message "Built-in plugins cannot be deleted" when an administrator attempts to run UNINSTALL PLUGIN on a component that is statically linked into the server binary. The server blocks the action to protect essential functionality.

Built-in plugins have no corresponding .so or .dll file on disk. Because they were compiled with the server, removing them at runtime would destabilize MySQL. The error was introduced in MySQL 5.7.5 to make that boundary explicit.

What Causes This Error?

The most common trigger is an UNINSTALL PLUGIN statement targeting a built-in authentication or replication module. Another cause is manual deletion of rows from the mysql.plugin table during maintenance scripts. Both actions force the plugin subsystem to validate the target and raise error 1619 if the plugin is compiled in.

Accidental executions often happen when copying shell commands from older documentation written for pluggable versions of the same component. Automated deployment tools that blindly uninstall unused plugins also generate the error.

How to Fix MySQL Error 1619 ER_PLUGIN_DELETE_BUILTIN

Stop trying to remove the built-in plugin. Instead, leave it installed or disable its functionality with configuration flags such as skip-plugin-name or by selecting a different default authentication plugin. Restart MySQL after editing the my.cnf file for the change to take effect.

If you modified the mysql.plugin table, restore the original row or run mysql_upgrade to rebuild plugin metadata. Always verify plugin status with SHOW PLUGINS before and after changes.

Common Scenarios and Solutions

Scenario: You attempted UNINSTALL PLUGIN auth_socket on Ubuntu packages. Solution: Remove the uninstall step and set default_authentication_plugin=mysql_native_password in my.cnf if you need the old behavior.

Scenario: A cleanup script deletes plugins marked "DEPRECATED". Solution: Add a whitelist of built-in plugins or filter by PLUGIN_LIBRARY column to avoid statically linked components.

Best Practices to Avoid This Error

Run SHOW PLUGINS and check the PLUGIN_LIBRARY column; NULL means the plugin is built-in and must not be uninstalled. Annotate deployment playbooks with this rule.

Store your operational SQL in Galaxy Collections so teammates reuse vetted maintenance scripts. Galaxy’s endorsement workflow highlights safe commands and prevents editing without review, reducing accidental UNINSTALL PLUGIN executions.

Related Errors and Solutions

Error 1524 (ER_GRANT_PLUGIN_USER_EXISTS) surfaces when authentication plugin data is inconsistent after a failed uninstall attempt. Re-create the user account with the correct plugin to resolve it.

Error 1123 (ER_UNKNOWN_STORAGE_ENGINE) is similar but occurs when a built-in storage engine is disabled incorrectly. Re-enable the engine in my.cnf and restart the server.

Common Causes

UNINSTALL PLUGIN on a compiled component

Administrators issue UNINSTALL PLUGIN against authentication_socket or other built-in modules.

Manual edits to mysql.plugin

Rows for built-in plugins are removed directly in the system table during cleanup.

Automated deployment scripts

CI/CD jobs uninstall all plugins not present in a manifest, ignoring built-in status.

Following outdated documentation

Old guides written for pluggable versions instruct users to uninstall now built-in plugins.

Related Errors

MySQL Error 1524: ER_GRANT_PLUGIN_USER_EXISTS

Appears when the user account references a missing authentication plugin.

MySQL Error 1123: ER_UNKNOWN_STORAGE_ENGINE

Raised when a required storage engine is disabled or unrecognised.

MySQL Error 1238: ER_BAD_PLUGIN_FILE

Occurs if a pluggable component’s shared library is unreadable or corrupted.

FAQs

Can I ever remove a built-in plugin?

No. You can only disable its usage via configuration, not uninstall it.

How do I know if a plugin is built-in?

Run SHOW PLUGINS and check the PLUGIN_LIBRARY column. NULL means built-in.

Will disabling a built-in plugin affect upgrades?

Minor upgrades keep your settings, but major version changes may reset defaults. Reapply my.cnf tweaks after upgrades.

How does Galaxy help prevent this error?

Galaxy’s endorsement and versioning features ensure maintenance scripts are peer-reviewed, reducing risky UNINSTALL commands.

Start Querying with the Modern SQL Editor Today!
Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)
Oops! Something went wrong while submitting the form.

Check out some other errors

Trusted by top engineers on high-velocity teams
Aryeo Logo
Assort Health
Curri
Rubie Logo
Bauhealth Logo
Truvideo Logo