Bug #111895 MySQL Workbench 8.0 is not backward compatible
Submitted: 26 Jul 14:36 Modified: 8 Aug 14:45
Reporter: andrew alsdorf Email Updates:
Status: Can't repeat Impact on me:
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 14:36] andrew alsdorf
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 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.

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

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

[27 Jul 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 :

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

Ashwini Patil
[27 Jul 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 14:22] andrew alsdorf
Restore connections utility also fails

Attachment: Restore Connections.png (image/png, text), 3.84 KiB.

[8 Aug 14:45] andrew alsdorf
Is anyone looking into this issue?