Loading

MySQL 9.x Driver Errors Occur When Connecting to Databases Using mysql_native_password Authentication

Publiceringsdatum: Oct 24, 2025
Beskrivning

When connecting to MySQL databases using the MySQL ODBC 9.x driver, users may encounter the following error:

[MySQL][ODBC 9.x(w) Driver]Authentication plugin 'mysql_native_password' cannot be loaded
Error Code: 0x3778034A

This issue occurs when the database account uses the legacy mysql_native_password authentication plugin. This article explains the compatibility change and available workarounds. The problem may appear when connecting live or refreshing data through Tableau Cloud, Tableau Server, or any application that uses the MySQL ODBC 9.x driver.

 

Cause

Beginning with MySQL 9.0, the mysql_native_password authentication plugin has been removed from the default ODBC driver build.

Important: MySQL ODBC 9.0.0 completely lacks authentication plugins, while 9.1+ versions include them but require proper plugin directory setup.

The 9.1 and later driver no longer embeds the plugin internally and instead attempts to load it dynamically from an external plugin directory. If the plugin directory does not exist or is not correctly linked, MySQL authentication will fail in Tableau, and Tableau will throw error code 0x3778034A.

You can identify which MySQL user accounts are configured to use the mysql_native_password authentication method by running the following query:

SELECT user, plugin FROM mysql.user WHERE plugin = 'mysql_native_password';
Lösning

Platform-specific guidance:

  • All platforms: Update to MySQL ODBC 9.1 or newer
  • Windows: No additional guidance needed
  • Linux (default installation): No additional action required - plugins are automatically available at /usr/lib64/mysql/libmyodbc9/plugin/
  • Mac or custom Linux installations: Follow the manual plugin path setup below

 

Manual Plugin Path Setup (for Mac or Custom Installations Only)
If you see detailed errors referencing missing files such as:

dlopen(/usr/local/mysql/lib/plugin/mysql_native_password.so, 0x0002): no such file

it means the driver cannot find the plugin directory.

By default, /usr/local/mysql/lib/plugin is a symlink that should point to the actual plugin folder inside your installed MySQL ODBC 9.x package.

For example, on macOS with the default installation path:

/usr/local/mysql-connector-odbc-9.4.0-macos15-arm64/lib/plugin


For Mac users:

  1. Option 1: Create a symlink so the driver can locate the correct plugin directory:
sudo ln -s /usr/local/mysql-connector-odbc-9.4.0-macos15-arm64/lib/plugin /usr/local/mysql/lib/plugin
  1. Option 2: Alternatively, move the missing plugin files (e.g., plugin/mysql_native_password.so or other plugin/*.so) into /usr/local/mysql/lib/.

 

For Linux users with custom installations:
If you used a non-default installation path, create a symlink: 

sudo ln -sf /your/custom/path/lib/plugin /usr/lib64/mysql/plugin

For example:

sudo ln -sf /opt/mysql-connector-odbc-9.4.0/lib/plugin /usr/local/mysql/lib/plugin

Note: Most Linux users with default installations should not need these steps, as plugins are automatically available at /usr/lib64/mysql/libmyodbc9/plugin/.

Ytterligare resurser
  • This issue affects any connection where the MySQL user is configured with the mysql_native_password authentication plugin.
  • Refer to the MySQL Connector/ODBC documentation for information on authentication plugin configuration.
Knowledge-artikelnummer

005226939

 
Laddar
Salesforce Help | Article