MySQL Bugs: #98194: MySQL server will not connect.

Bug #98194	MySQL server will not connect.
Submitted:	12 Jan 2020 7:56	Modified:	15 Jan 2020 3:38
Reporter:	Michael Hall	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S2 (Serious)
Version:	8.0.18	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

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

Can not get a MySQL server connection on 127.0.0.1:3306. Can't get any MySQL server connections. This is the second time around with this report. 

How to repeat:
Only if the server refuses to connect.

Suggested fix:
I am contacting you for the fix, hope you can find the problem.

Logs:23:26:39 [ERR][      Workbench]: Console redirection failed.
23:26:39 [INF][      Workbench]: Starting up Workbench
23:26:39 [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: 79655078
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41590784
23:26:39 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-KLOB32S
	USERPROFILE = C:\Users\Michael
	HOMEPATH = \Users\Michael
	LOCALAPPDATA = C:\Users\Michael\AppData\Local
	PSModulePath = 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-KLOB32S
	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
	APPDATA = C:\Users\Michael\AppData\Roaming
	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)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Traders Way MetaTrader 4;C:\Program Files (x86)\FXCM MetaTrader 4;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Michael\AppData\Local\Microsoft\WindowsApps;
	USERNAME = Michael
	OneDrive = C:\Users\Michael\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-KLOB32S
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 23 Stepping 10, GenuineIntel
	OneDriveConsumer = C:\Users\Michael\OneDrive
	USERDOMAIN = DESKTOP-KLOB32S
	SystemDrive = C:
	TEMP = C:\Users\Michael\AppData\Local\Temp
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 2
	ComSpec = C:\WINDOWS\system32\cmd.exe
	TMP = C:\Users\Michael\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	PROCESSOR_REVISION = 170a
	PUBLIC = C:\Users\Public
23:26:39 [INF][      Workbench]: Current version given by meta info is: 8.0.18
23:26:39 [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)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Traders Way MetaTrader 4;C:\Program Files (x86)\FXCM MetaTrader 4;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Michael\AppData\Local\Microsoft\WindowsApps;
23:26:39 [INF][ mforms managed]: Initializing mforms wrapper
23:26:40 [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\Michael\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
23:26:40 [INF][      WBContext]: WbContext::init
23:26:45 [INF][            WBA]: Looking for extension modules for WBA...
23:26:45 [INF][            WBA]: 0 extension modules found
23:26:46 [WRN][            grt]: C:\Users\Michael\AppData\Roaming\MySQL\Workbench\connections.xml:25: link '{01A37155-7921-4756-B3E1-D2BA69F7AA96}' <object GrtObject> key=owner could not be resolved
23:26:46 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.18 CE build 15329599 (64 bit)
	Configuration Directory: C:\Users\Michael\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: 2x Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz, 3.9 GiB RAM
	Active video adapter Trigger II External Graphics
	Installed video RAM: 0 MB
	Current video mode: 1360 x 768 x 4294967296 colors
	Used bit depth: 32
	Driver version: 1.4.1704.628
	Installed display drivers: NULL
	Current user language: English (United States)

23:26:47 [INF][      Workbench]: UI is up
23:26:47 [INF][      Workbench]: Running the application
23:26:55 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (10061)
23:26:55 [WRN][SQL Editor Form]: Can't connect to MySQL server on '127.0.0.1' (10061)
23:26:55 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
23:26:55 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
23:26:56 [INF][        WQE.net]: Launching SQL IDE
23:26:58 [INF][        WQE.net]: SQL IDE UI is ready
23:27:01 [ERR][wb_admin_control.py:init:307]: Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)
23:27:03 [ERR][wb_admin_control.py:server_polling_thread:561]: Error creating SQL connection for monitoring: MySQLError("Can't connect to MySQL server on '127.0.0.1' (10061) (code 2003)",)
23:27:03 [ERR][wb_admin_control.py:get_config_options:760]: Could not open the file "\\<server>\C$\Program Files\MySQL\MySQL Server 8.0\my.ini": [Errno 22] invalid mode ('r') or filename: '\\\\<server>\\C$\\Program Files\\MySQL\\MySQL Server 8.0\\my.ini'
23:27:03 [INF][wb_admin_control.py:query_server_installation_info:860]: Currently connected to MySQL server version 'unknown', conn

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

"Can't connect to MySQL server on '127.0.0.1' (10061)"
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html

Can you forward this report to the proper department that will look at this problem and repair it please.

Thank You, Michael Hall.