Bug #107272 can't connect remote server after upgrade to v8.0.29
Submitted: 12 May 2022 12:13 Modified: 22 Jul 2022 10:48
Reporter: Terry z Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.29 OS:MacOS (macOS 12.x Monterey x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[12 May 2022 12:13] Terry z
Description:
19:55:58 [INF][      Workbench]: Starting up Workbench
19:55:58 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /Applications/MySQLWorkbench.app/Contents/Resources
	plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
	struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
	module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
	library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
	user data dir: /Users/hiwanz/Library/Application Support/MySQL/Workbench
	open at start:
	open type:
	run at startup:
	run type:
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
19:55:58 [INF][      WBContext]: WbContext::init
19:55:58 [INF][            WBA]: Looking for extension modules for WBA...
19:55:58 [INF][            WBA]: 0 extension modules found
19:55:59 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
19:55:59 [WRN][            grt]: /Users/hiwanz/Library/Application Support/MySQL/Workbench/connections.xml:26: link 'E870F23C-407E-4340-9F10-67933F995327' <object GrtObject> key=owner could not be resolved
19:55:59 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
19:55:59 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for macOS version 8.0.29 CE build 1751076 (64 bit)
	Configuration Directory: /Users/hiwanz/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.17.4
	OS: macOS 12.x Monterey x86_64
	CPU: 4x Intel(R) Core(TM) i5-7267U CPU @ 3.10GHz - 8.00GiB RAM
No video adapter info available

19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_sakila_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_manage_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_folder@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_network_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_plus_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_user_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_plus_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_doc_sql@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_number_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_close@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_open_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_more_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_sakila_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_manage_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_folder@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_network_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_plus_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_user_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_plus_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_doc_sql@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_number_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_close@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_open_light@2x.png
19:55:59 [WRN][         mforms]: Resource file not found: wb_tile_more_light@2x.png
19:56:06 [WRN][         mforms]: Resource file not found: MySQL-WB-about-screen@2x@2x.png
19:56:33 [INF][      WBContext]: Connection to db.test.sh-weiyi.com cancelled by user: canceled
19:57:37 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Unable to connect to localhost
19:57:37 [WRN][SQL Editor Form]: Unable to connect to localhost
19:57:37 [ERR][SQL Editor Form]: Connection failed but remote admin does not seem to be available, rethrowing exception...
19:57:37 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Unable to connect to localhost
19:57:37 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Unable to connect to localhost
19:57:37 [ERR][    WQE backend]: Got an exception during connection: Unable to connect to localhost
20:02:16 [WRN][         mforms]: Resource file not found: MySQL-WB-about-screen@2x@2x.png
20:03:05 [WRN][         mforms]: Resource file not found: MySQL-WB-about-screen@2x@2x.png

How to repeat:
It worked fine with lower version workbrench, I downloaded v8.0.29 dmg file, drag and replace the old one in Application folder, opened it again, try connecting a remote server which definitely not localhost, but it failed and said:

Your connection attempt failed for user 'whatever' to the MySQL server at whatever.mysql.rds.whatever.com:3306:
Unable to connect to localhost

why localhost here???
[12 May 2022 12:18] Terry z
change serverity
[22 Jul 2022 10:48] MySQL Verification Team
Hello Terry,

Thank you for the bug report.
I've tried to reproduce your issue on a Mac with workbench 8.0.29 but not seeing any issues at my end.
Discussed internally with the WB developers and confirmed that it is not seen.
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,
Ashwini Patil