Bug #116399 Cannot Connect to Database as root in 8.0.40
Submitted: 18 Oct 0:05 Modified: 18 Oct 3:59
Reporter: Rob Roselius Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.40 OS:MacOS
Assigned to: CPU Architecture:Any

[18 Oct 0:05] Rob Roselius 
Description:
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)

How to repeat:
* Run MySQL Workbench 8.0.40 on MacOS
* Connect to localhost as root
[18 Oct 3:59] MySQL Verification Team 
Hello Rob Roselius,

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

regards,
Umesh
[5 Nov 8:19] MySQL Verification Team 
Hello Rob Roselius,

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