MySQL Bugs: #116377: Unable to log in after upgrading to workbench 8.0.40

Bug #116377	Unable to log in after upgrading to workbench 8.0.40
Submitted:	16 Oct 2024 13:49	Modified:	5 Nov 2024 10:26
Reporter:	IGG t	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	8.0.40	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
I just upgraded from MySQL Workbench 8.0.38 to 8.0.40, and following the update I was unable to log into any databases. I simply got the error:

Exception: Authentication plugin '' cannot be loaded: The specified module could not be found

This was the same on all databases I tried, the majority are running MySQL 8.0.39
My User is using caching_sha2_password.

Downgrading back to workbench 8.0.38 fixed the problem.

How to repeat:
Confirm you can access MySQL

download and upgrade workbench to 8.0.40

Try and login again.

Suggested fix:
Make it so that workbench can find the specified module.

I have exactly the same problem.

I encountered the same error after upgrading from 8.0.25 to 8.0.40.

Uninstalled 8.0.40 and installed 8.0.38 (based user 'IGG t' saying their 8.0.38 was working OK) and that worked.

This is what the log says

14:08:54 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.40 CE build 4545542 (64 bit)
	Configuration Directory: C:\Users\sebin\AppData\Roaming\MySQL\Workbench
	Data Directory: D:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.18.0
	OS: Microsoft Windows 10 Pro
	CPU: 8x Intel(R) Core(TM) i5-10210U CPU @ 1.60GHz, 15.7 GiB RAM
	Active video adapter Intel(R) UHD Graphics
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1080 x 4294967296 colors
	Used bit depth: 32
	Driver version: 30.0.101.1338
	Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_52ad2da9d64c0488\igdumdim64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_52ad2da9d64c0488\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_52ad2da9d64c0488\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_52ad2da9d64c0488\igd12umd64.dll
	Current user language: English (New Zealand)

14:08:54 [INF][      Workbench]: UI is up
14:08:54 [INF][      Workbench]: Running the application
14:09:30 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found.

14:09:30 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found.

14:09:30 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found.

14:09:31 [ERR][SQL Editor Form]: SQL editor could not be connected: Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found.

14:09:31 [ERR][SQL Editor Form]: Your connection attempt failed for user 'candidate-360' to the MySQL server at 127.0.0.1:3306:
  Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found.

Bug #116384 marked as duplicate of this one

Hello IGG t,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh

Bug #116395 marked as duplicate of this one

Also started happening on MacOS Sequioa with upgrade to version 8.0.40

Seen on Windows/MacOS (surely on other WB supported OS platforms as well)

Bug #116399 marked as duplicate of this one

Similar issue on MacOS, MWB 8.0.40

When trying to connect as root to MySQL server (MAMP 7.1, mysql 8.0.35), MWB cannot connect:

Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
Authentication plugin 'mysql_native_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/mysql_native_password.so, 0x0002): tried: '/usr/local/mysql/lib/plugin/mysql_native_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/mysql/lib/plugin/mysql_native_password.so' (no such file), '/usr/local/mysql/lib/plugin/mysql_native_password.so' (no such file)

Bug #116413 marked as duplicate of this one

Bug #116417 marked as duplicate of this one

Same problem here. Windows 11 running Workbench 8.0.40

Bug #116416 marked as duplicate of this one

Upgraded from 8.0.38 to 8.0.40 and encountering same issue.

I notice verification team is just closing out duplicate bugs but no investigation/fix is being attempted (yet).

Really? MySQL workbench 8.0.40 isn't compatible with 8.0.40 server? Is there anyone even doing the minimal amount of testing at Oracle for this enterprise product?

Same problem here. Windows 11 running Workbench 8.0.40

Same issue on macOS Sequoia running Workbench 8.0.40. 8.0.38 works fine

We noticed that we can connect with users that were CREATED with the caching_sha2_password plugin.

If we change the authentication plugin for users created with mysql_native_password to caching_sha2_password, we see the error message:

Authentication plugin '' cannot be loaded: The specified module could not be found

For users that use mysql_native_password, we see the error message:

Authentication plugin 'mysql_native_password' cannot be loaded: The specified module could not be found

Dropping and re-creating the user with caching_sha2_password fixes the connection problem.

However, changing the authentication method from mysql_native_password to caching_sha2_password should also fix the connection (which it does not, see above).

Correction on my previous comment "[23 Oct 7:11] Michael Roemer":

We see the error "Authentication plugin '' cannot be loaded: The specified module could not be found" only if the default_authentication_plugin is set to mysql_native_plugin (SHOW VARIABLES LIKE 'default_authentication_plugin').

When we change the default_authentication_plugin to caching_sha2_password, changing the authentication plugin for a user from mysql_native_password to caching_sha2_password allows connection.

Hi All,

Thanks for reporting the issue.

libmysqlclient (as used by MySQL Connector/C++ 9.1.0 as used by MySQL Workbench) moved the support for mysql_native_password into a loadable plugin, mysql_native_password.so / .dll and it seems we missed to add this file to the package creation scripts before creating the final MySQL Workbench packages.

We will review our MySQL Workbench packaging scripts, fix the issue and re-release the MySQL Workbench packages.

Thanks,
Mike

Bug #116481 marked as duplicate of this one

Bug #116483 marked as duplicate of this one

It is really worrying that you have not tested the final distributed package.
Since it always gives an error to all users, with any connection to DBs, it is impossible not to notice it when you try it. ISO9000?

Bug #116493 marked as duplicate of this one

This bug taking so long to resolve, I have now dropped MySQL Workbench and started using other better clients like DBeaver.

This bug taking so long to resolve, I have now dropped MySQL Workbench and started using other better clients like DBeaver.

Bug #116533 marked as duplicate of this one

https://dev.mysql.com/doc/relnotes/workbench/en/news-8-0-40.html

8.0.40 WB was re-released again.  Did anybody check if that resolves it?

Thanks for the bug report.

We have re-published the Workbench 8.0.40 release with the mysql_native_password authentication plugin fix.

If you installed the original release, then uninstall it before installing the newer version.

I can confirm that the newly published 8.0.40 fixes the issue for me on Mac Sequioa

Bug #117789 marked as duplicate of this one

It's just a shame that it took so long. What does it tell us - users/ customers?

I can confirm 8.0.40 WB re-release resolves. Also 8.0.41 work
Windows 10