Bug #98885 Won't connect to the localhost:3306
Submitted: 10 Mar 2020 2:31 Modified: 13 Apr 2020 8:26
Reporter: Destiny Clarke Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S7 (Test Cases)
Version:8.0.19 OS:Windows (Microsoft Windows 10 Home)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[10 Mar 2020 2:31] Destiny Clarke
Description:

20:21:09 [ERR][      Workbench]: Console redirection failed.
20:21:09 [INF][      Workbench]: Starting up Workbench
20:21:09 [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: 259281
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 42086400
20:21:09 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-EPL3PK6
	USERPROFILE = C:\Users\Tiny
	HOMEPATH = \Users\Tiny
	LOCALAPPDATA = C:\Users\Tiny\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	CommonProgramW6432 = C:\Program Files\Common Files
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\DESKTOP-EPL3PK6
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\Windows
	ChocolateyInstall = C:\ProgramData\chocolatey
	ChocolateyLastPathUpdate = 132189396441540140
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	APPDATA = C:\Users\Tiny\AppData\Roaming
	Path = C:\Python27\;C:\Python27\Scripts;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\nodejs\;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\Users\Tiny\AppData\Local\Microsoft\WindowsApps;C:\Users\Tiny\AppData\Local\GitHubDesktop\bin;C:\Users\Tiny\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\heroku\bin;C:\Users\Tiny\AppData\Roaming\npm
	USERNAME = Tiny
	OneDrive = C:\Users\Tiny\OneDrive
	TEMP = C:\Users\Tiny\AppData\Local\Temp
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-EPL3PK6
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 158 Stepping 10, GenuineIntel
	OneDriveConsumer = C:\Users\Tiny\OneDrive
	SESSIONNAME = Console
	USERDOMAIN = DESKTOP-EPL3PK6
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 12
	ComSpec = C:\Windows\system32\cmd.exe
	TMP = C:\Users\Tiny\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\Windows
	PROCESSOR_REVISION = 9e0a
	PUBLIC = C:\Users\Public
20:21:09 [INF][      Workbench]: Current version given by meta info is: 8.0.19
20:21:09 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\nodejs\;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\Users\Tiny\AppData\Local\Microsoft\WindowsApps;C:\Users\Tiny\AppData\Local\GitHubDesktop\bin;C:\Users\Tiny\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\heroku\bin;C:\Users\Tiny\AppData\Roaming\npm
20:21:09 [INF][ mforms managed]: Initializing mforms wrapper
20:21:09 [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\Tiny\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
20:21:09 [INF][      WBContext]: WbContext::init
20:21:12 [INF][            WBA]: Looking for extension modules for WBA...
20:21:12 [INF][            WBA]: 0 extension modules found
20:21:12 [WRN][            grt]: C:\Users\Tiny\AppData\Roaming\MySQL\Workbench\server_instances.xml:22: link '{392DF1FD-A36D-40A0-AB66-512D8D688861}' <object GrtObject> key=owner could not be resolved
20:21:12 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.19 CE build 15713499 (64 bit)
	Configuration Directory: C:\Users\Tiny\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Home
	CPU: 12x Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz, 15.8 GiB RAM
	Active video adapter Trigger 6 External Graphics
	Installed video RAM: 0 MB
	Current video mode: 1920 x 1080 x 4294967296 colors
	Used bit depth: 32
	Driver version: 1.4.1902.1018
	Installed display drivers: NULL
	Current user language: English (United States)

20:21:12 [INF][      Workbench]: UI is up
20:21:12 [INF][      Workbench]: Running the application
20:21:19 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Unable to connect to localhost:3306
20:21:19 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Unable to connect to localhost:3306
20:21:19 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Unable to connect to localhost:3306
20:21:19 [ERR][    WQE backend]: Got an exception during connection: Unable to connect to localhost:3306
20:21:19 [ERR][SQL Editor Form]: SQL editor could not be connected: Unable to connect to localhost:3306
20:21:19 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
  Unable to connect to localhost:3306

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

How to repeat:
Open mySQL Workbench

let it load your connections

Open your local connection
-------This will load a while and then tell you that it wasn't able to connect to the localhost:3306

Suggested fix:

I don't know a suggested fix. I need this for class, and I can't get it to work.
[10 Mar 2020 2:49] Destiny Clarke
log

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

[13 Mar 2020 8:26] MySQL Verification Team
Thank you for the bug report. Please provide the MySQL Server version are you trying to connect to and a screenshot when you connected with mysql.exe command client to.
[14 Apr 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".