Bug #111752 Cannot make any remote connections

• Submitted: 13 Jul 2023 20:20
• Modified: 31 Jul 2023 13:00
• Reporter: Jack Edwards
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 8.0.28, 8.0.33
• OS: Windows (Microsoft Windows 11)
• CPU Architecture: x86
• Tags: WBBugReporter

[13 Jul 2023 20:20] Jack Edwards

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\jack\AppData\Roaming\MySQL\Workbench\log\wb.log]

MySQL Workbench fails to make any remote connections.  I first encountered this on the latest version of Workbench.  After discovering similar bugs I tried on Workbench v8.0.28, but the error persists.

Help => Check for updates
 - "Check for updates failed"
 - "<urlopenerror unknown url type: https>"
 - "Please verify that your internet connection is available."

Attempting to connect to a remote database:
 - "Cannot Connect to Database Server"
 - "Your connection attempt failed for user 'redacted' to the MySQL server at 'redacted:3306: Unable to connect to localhost"

I've re-installed Workbench several times.  I re-installed Python 3.11, as many people who encounter the urlopenerror are performing Python development.  I've installed the latest Windows updates.  I've cleared Workbench data from my appdata.  The errors persist.

How to repeat:
Install MySQL Workbench and try to make a remote connection.

[13 Jul 2023 20:24] Jack Edwards

Updated 'Version' with 8.0.33

[18 Jul 2023 12:19] MySQL Verification Team

Hello Jack Edwards,

Thank you for the bug report.
Please try as suggested in the error log :

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

Regards,
Ashwini Patil

[28 Jul 2023 15:07] Jack Edwards

I have tried following those suggestions.  The problem is not with the server or the connection information.  The problem is with the Workbench client, which cannot even check for updates.

[31 Jul 2023 13:00] MySQL Verification Team

Hello Jack,

For "Check for updates" issue: 
Imho this is duplicate of Bug #110786, please see Bug #110786.

Regards,
Ashwini Patil