Bug #93852 Bad handshake , Workbench version 8.0.13 build 13780177
Submitted: 8 Jan 2019 13:25 Modified: 15 May 2019 9:14
Reporter: Clever Vieira Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.13 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[8 Jan 2019 13:25] Clever Vieira
Description:
10:00:29 [ERR][      Workbench]: Console redirection failed.
10:00:29 [INF][      Workbench]: Starting up Workbench
10:00:29 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 84091531
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 40591360
10:00:29 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = TI-CLEVER
	USERPROFILE = C:\Users\Clever
	HOMEPATH = \Users\Clever
	LOCALAPPDATA = C:\Users\Clever\AppData\Local
	PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\
	PROCESSOR_ARCHITECTURE = AMD64

How to repeat:
10:00:29 [ERR][      Workbench]: Console redirection failed.
10:00:29 [INF][      Workbench]: Starting up Workbench
10:00:29 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 84091531
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 40591360
10:00:29 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = TI-CLEVER
	USERPROFILE = C:\Users\Clever
	HOMEPATH = \Users\Clever
	LOCALAPPDATA = C:\Users\Clever\AppData\Local
	PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\MySQL\MySQL Utilities 1.6\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Symantec.cloud\PlatformAgent\;C:\Program Files\PuTTY\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Users\Clever\AppData\Local\Microsoft\WindowsApps;
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\TI-CLEVER
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\WINDOWS
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	SSMA_M2SS_EP_HOME = C:\Program Files\Microsoft SQL Server Migration Assistant for MySQL Extension Pack\
	APPDATA = C:\Users\Clever\AppData\Roaming
	PROCESSOR_REVISION = 4e03
	USERNAME = Clever
	CommonProgramW6432 = C:\Program Files\Common Files
	OneDrive = C:\Users\Clever\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = TI-CLEVER
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 78 Stepping 3, GenuineIntel
	ComSpec = C:\WINDOWS\system32\cmd.exe
	SystemDrive = C:
	TEMP = C:\Users\Clever\AppData\Local\Temp
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 4
	TMP = C:\Users\Clever\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = TI-CLEVER
	PUBLIC = C:\Users\Public
10:00:29 [INF][      Workbench]: Current version given by meta info is: 8.0.13
10:00:29 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\MySQL\MySQL Utilities 1.6\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Symantec.cloud\PlatformAgent\;C:\Program Files\PuTTY\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Users\Clever\AppData\Local\Microsoft\WindowsApps;
10:00:29 [INF][ mforms managed]: Initializing mforms wrapper
10:00:29 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	user data dir: C:\Users\Clever\AppData\Roaming\MySQL\Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
10:00:29 [INF][      WBContext]: WbContext::init
10:00:30 [INF][            WBA]: Looking for extension modules for WBA...
10:00:30 [INF][            WBA]: 0 extension modules found
10:00:30 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules/data/mysql_rdbms_info.xml:1401: link 'om.mysql.rdbms.mysql.driver.native_sshtun' <object > key=owner could not be resolved
10:00:30 [WRN][            grt]: C:\Users\Clever\AppData\Roaming\MySQL\Workbench\connections.xml:23: link '{A1882356-F042-4BC7-8900-5B7E3D93B753}' <object GrtObject> key=owner could not be resolved
10:00:30 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.13 CE build 13780177 (64 bit)
	Configuration Directory: C:\Users\Clever\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro
	CPU: 4x Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz, 11.9 GiB RAM
	Active video adapter Intel(R) HD Graphics 520
	Installed video RAM: 1024 MB
	Current video mode: 1366 x 768 x 4294967296 colores
	Used bit depth: 32
	Driver version: 20.19.15.4531
	Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igd12umd64.dll
	Current user language: Portugués (Brasil)

10:00:30 [INF][      Workbench]: UI is up
10:00:31 [INF][      Workbench]: Running the application
10:00:37 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Bad handshake
10:00:37 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Bad handshake
10:00:37 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Bad handshake
10:00:37 [ERR][    WQE backend]: Got an exception during connection: Bad handshake
10:00:37 [ERR][SQL Editor Form]: SQL editor could not be connected: Bad handshake
10:00:37 [ERR][SQL Editor Form]: Your connection attempt failed for user 'consulta' from your host to server at X.X.X.X:3306:
  Bad handshake

Please:
1 Check that mysql is running on server X.X.X.X
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the consulta has rights to connect to X.X.X.X 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 192.168.2.102 connecting from the host address you're connecting from
10:17:44 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Bad handshake
10:17:44 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Bad handshake
10:17:44 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Bad handshake
10:17:45 [ERR][SQL Editor Form]: SQL editor could not be connected: Bad handshake
10:17:45 [ERR][SQL Editor Form]: Your connection attempt failed for user 'Presupuesto' from your host to server at X.X.X.X:3306:
  Bad handshake

Please:
1 Check that mysql is running on server X.X.X.X
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the Presupuesto has rights to connect to X.X.X.X 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 192.168.2.102 connecting from the host address you're connecting from
[15 May 2019 9:14] MySQL Verification Team
Thank you for the bug report. I couldn't repeat with WorkBench 8.0.16 connecting with servers 5.6/5.7/8.0.