MySQL Bugs: #116416: Workbench has encountered a problem

Bug #116416	Workbench has encountered a problem
Submitted:	19 Oct 9:48	Modified:	22 Oct 5:10
Reporter:	Maq M	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.40	OS:	Windows (Windows 10 x64)
Assigned to:		CPU Architecture:	Any

Description:
I have 2 computers with Workbench 8.0.40 and 8.0.36. Both Windows 10 x64. Both connect to remote network via VPN. Both can successfully install connection to remote server via SSH (with putty). MySQL DB is on remote server.
But one computer (8.0.40) cannot connect to the same MySQL with the same credentials (Standard TCP/IP over SSH, all passwords are correct).
When testing connection I get error "MySQL Workbench has encountered a problem".
No antivirus or enabled firewall present.

How to repeat:
I cannot see the way to repeat since it happens on my computer.

Hello Maq M,

Thank you for the report and feedback.
To investigate further this issue at our end, may I kindly request you
to launch workbench under debug mode (--log-level=debug3) and provide
unaltered workbench log file(more details about log are explained here
-
https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)?

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.

regards,
Umesh

Dear Umesh.
Thank you for your feedback.
Please find attached the log files.

Regards,
Rauf

Hello Rauf,

Thank you for the requested details.
IMHO this issue is duplicate of Bug #116377, please see Bug #116377.

##
21:41:15 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Authentication plugin 'mysql_native_password' cannot be loaded: Íå íàéäåí óêàçàííûé ìîäóëü.

21:41:15 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Authentication plugin 'mysql_native_password' cannot be loaded: Íå íàéäåí óêàçàííûé ìîäóëü.

21:41:15 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Authentication plugin 'mysql_native_password' cannot be loaded: Íå íàéäåí óêàçàííûé ìîäóëü.

21:41:15 [ERR][    WQE backend]: Got an exception during connection: Authentication plugin 'mysql_native_password' cannot be loaded: Íå íàéäåí óêàçàííûé ìîäóëü.

21:41:15 [ERR][SQL Editor Form]: SQL editor could not be connected: Authentication plugin 'mysql_native_password' cannot be loaded: Íå íàéäåí óêàçàííûé ìîäóëü.

21:41:15 [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: Íå íàéäåí óêàçàííûé ìîäóëü.

regards,
Umesh

Hello Maq M

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