Bug #111895 MySQL Workbench 8.0 is not backward compatible
Submitted: 26 Jul 2023 14:36 Modified: 8 Aug 2023 14:45
Reporter: andrew alsdorf Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.33 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Jul 2023 14:36] andrew alsdorf 
Description:
After upgrade to 8.0 existing SQL will not execute.  Fails with "unable to connect to localhost" error.  The MySQL server configured in the connection is not local.

How to repeat:
Install MySQL 6.5 Workbench establish connection to database server.
Upgrade to MySQL 8.0 and attempt to connect to the same database.
[27 Jul 2023 11:29] MySQL Verification Team 
Hello Andrew,

Thank you for the bug report.
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)? Thanks.

Regards,
Ashwini Patil
[27 Jul 2023 11:52] andrew alsdorf 
Error during MySQL connection

Attachment: wb.log (application/octet-stream, text), 43.15 KiB.
[27 Jul 2023 12:52] MySQL Verification Team 
Hello Andrew,

Thank you for the details.
I tried to reproduce your issue on Windows 10 and upgraded workbench to latest version but I am not seeing any issues at my end.

Please try as suggested in the error log :

Please:
1 Check that MySQL is running on address svn.genpt.net
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user jiffy has rights to connect to svn.genpt.net 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 svn.genpt.net connecting from the host address you're connecting from

Regards,
Ashwini Patil
[27 Jul 2023 12:56] andrew alsdorf 
There is no problem with the server.  I am able to uninstall version 8 and reinstall version 6 with ALL connections working.  Also, MS PowerBI is using the MySQL data and has no problem with the connection.  The issue lies with Workbench; why is Workbench looking for/assuming a "localhost" connection?
[27 Jul 2023 14:22] andrew alsdorf 
Restore connections utility also fails

Attachment: Restore Connections.png (image/png, text), 3.84 KiB.
[8 Aug 2023 14:45] andrew alsdorf 
Is anyone looking into this issue?