MySQL Bugs: #116533: MySQL Workbench 8.0 CE 4.0.30319.4200 'mysql_native

Bug #116533	MySQL Workbench 8.0 CE 4.0.30319.4200 'mysql_native_password' cannot be loaded
Submitted:	3 Nov 2024 10:36	Modified:	4 Nov 2024 5:10
Reporter:	André verwijs	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.40	OS:	Windows (Microsoft Windows 11 Pro)
Assigned to:		CPU Architecture:	Any (x64)
Tags:	authentication plugins

Description:
11:30:29 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at 127.0.0.1:3306:
  Authentication plugin 'mysql_native_password' cannot be loaded.

Please:
1 Check that MySQL is running on address 127.0.0.1
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user root has rights to connect to 127.0.0.1 from your address (MySQL rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

How to repeat:
--

Suggested fix:
--

added: Workbench log..

Attachment: wb.log (application/octet-stream, text), 10.11 KiB.

with "dbeaver" i have no issues, i can connect ....

Hello André verwijs,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #116377, please see Bug #116377.

regards,
Umesh

Hello André verwijs,

MySQL Workbench 8.0.40 was originally released on October 15, 2024, without the mysql_native_password authentication plugin. The issue was addressed and Workbench 8.0.40 was re-released with the fix on October 31, 2024. If you installed the original release, then uninstall it before installing the newer version. Please see - https://dev.mysql.com/doc/relnotes/workbench/en/news-8-0-40.html

regards,
Umesh