Bug #79132 MySQL crashes connecting to Remote Database
Submitted: 5 Nov 2015 8:02 Modified: 5 Nov 2015 20:31
Reporter: Abhilasha Kamath Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:mysql-installer-web-community-5.7.9.0 OS:Windows (Windows 10 64-bit)
Assigned to: CPU Architecture:Any

[5 Nov 2015 8:02] Abhilasha Kamath
Description:
I have the following installed as part of the MySQL Workbench Installation:
mysql-workbench-community-6.3.5-winx64
vcredist_x64
python-3.4.3.amd64
mysql-connector-python-2.1.3-py3.4-winx64
vs_community
mysql-for-visualstudio-1.2.4
(I was forced to install Python and Visual Studio as part of the full installation)

When I open MySQL and click on My Connections and enter the Connection Name and Hostname and Username and then click on Store in Vault to save my remote connection password, MySQL crashes. Instead if I click on test connection, it still crashes. I have tried to uninstall and reinstall MySQL 3 times. 

I tried the installation on a different PC (Windows 7 32-bit) and it crashed there as well. 

I also tried deleting the directory C:\Users\Username\AppData\Roaming\MySQL\Workbench but it crashed even after that.

The error log is as follows:

01:50:42 [ERR][      Workbench]: Console redirection failed.
01:50:42 [INF][      WBContext]: Parsing application arguments.
01:50:42 [INF][      WBContext]:     C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
01:50:42 [INF][      Workbench]: Starting up Workbench
01:50:42 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 519008531
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 34164736
01:50:42 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = USERNAME
	USERPROFILE = C:\Users\UserName
	HOMEPATH = \Users\UserName
	LOCALAPPDATA = C:\Users\UserName\AppData\Local
	asl.log = Destination=file
	PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Skype\Phone\;C:\Users\UserName\AppData\Local\Pandoc\
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\MicrosoftAccount
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY
	HOMEDRIVE = C:
	SystemRoot = C:\WINDOWS
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 37 Stepping 5, GenuineIntel
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	PUBLIC = C:\Users\Public
	FP_NO_HOST_CHECK = NO
	APPDATA = C:\Users\UserName\AppData\Roaming
	PROCESSOR_REVISION = 2505
	USERNAME = UserName
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\ABHILA~1\AppData\Local\Temp
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = USERNAME
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	ComSpec = C:\WINDOWS\system32\cmd.exe
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 4
	VS140COMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools\
	TMP = C:\Users\ABHILA~1\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = USERNAME
01:50:42 [INF][      Workbench]: Current version given by meta info is: 6.3.5
01:50:42 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Skype\Phone\;C:\Users\UserName\AppData\Local\Pandoc\
01:50:42 [INF][ mforms managed]: Initializing mforms wrapper
01:50:43 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	user data dir: C:\Users\UserName\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
01:50:43 [INF][      WBContext]: WbContext::init
01:50:45 [INF][            grt]: Scanning module directory C:\Users\UserName\AppData\Roaming\MySQL\Workbench\modules.	
01:50:45 [INF][            grt]: Scanning module directory ..	
01:50:45 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.	
01:50:53 [INF][            WBA]: Looking for extension modules for WBA...
01:50:53 [INF][            WBA]: 0 extension modules found
01:50:53 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
01:50:53 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
01:50:53 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
01:50:53 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.	
01:50:55 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit)
	Configuration Directory: C:\Users\UserName\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro
	CPU: 4x Intel(R) Core(TM) i5 CPU       M 520  @ 2.40GHz, 3.8 GiB RAM
	Active video adapter Intel(R) HD Graphics
	Installed video RAM: 1722 MB
	Current video mode: 1366 x 768 x 4294967296 colors
	Used bit depth: 32
	Driver version: 8.15.10.2900
	Installed display drivers: igdumd64.dll,igd10umd64.dll,igdumdx32,igd10umd32
	Current user language: English (United States)

01:50:55 [INF][      Workbench]: UI is up
01:50:59 [INF][      Workbench]: Running the application

How to repeat:
Not sure because MySQL installs fine and works fine only while connecting to the Remote Database through Manage Connections or Connect to Database it crashes. 

Suggested fix:
Not sure, I've tried everything I could.
[5 Nov 2015 10:12] Chiranjeevi Battula
Hello  Abhilasha Kamath,

Thank you for the bug report.
I tried to reproduce the issue at my end using MySQL community 5.7.9 version but not seeing any issue in Workbench 6.3.5 and able to connect remote MySQL databases..
This is most likely duplicate of Bug #69572, please see Bug #69572.

Thanks,
Chiranjeevi.
[5 Nov 2015 20:31] Abhilasha Kamath
Thanks Chiranjeevi but it is not clear from Bug #69572 what is the solution to the problem. I tried to disable secure auth (image attached), then closed MySQL 5.7 Command Line Client and ran MySQL Workbench 6.3 again, but I still faced the same problem (image attached). There is no problem with my username and password as it is working on a other MySQL Workbench 6.3s.