Bug #102070 cannot connect to database server
Submitted: 25 Dec 2020 3:33 Modified: 26 Dec 2020 18:42
Reporter: Gerry Mildenberger Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:8.0.22 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Any (i5 8400 2.8Ghz 64 bit)
Tags: WBBugReporter

[25 Dec 2020 3:33] Gerry Mildenberger
Description:
Had running version of MySQL Workbench 8.0.12.0 & other MySQL programs
Uninstalled all MySQL apps using SETTINGS, APPS, uninstall each
Installed newer version of MySQL Community Server programs, Workbench 8.0.22.0 and now anytime it starts up, I cannot connect to database server

How to repeat:
Had running version of MySQL Workbench 8.0.12.0 & other MySQL programs
Uninstalled all MySQL apps using SETTINGS, APPS
Installed newer version of MySQL Community Server programs, Workbench 8.0.22.0 and now anytime it starts up, I cannot connect to database server

Have reloaded all programs multiple times, same result

Cannot Connect to Database Server
Your connection attempt failed for user 'root' to the MySQL server at 197.0.0.1:3306
Access denied for user 'root'@'localhost' (using password: YES)

***Please help me gmilden5@shaw.ca***   780-249-2234
when you can

log file:
19:41:51 [ERR][      Workbench]: Console redirection failed.
19:41:51 [INF][      Workbench]: Starting up Workbench
19:41:51 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 2175187
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41504768
19:41:51 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-GG1BEM8
	USERPROFILE = C:\Users\Gerry Mildenberger
	HOMEPATH = \Users\Gerry Mildenberger
	LOCALAPPDATA = C:\Users\Gerry Mildenberger\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
	VS150COMCOMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\Tools\
	LOGONSERVER = \\DESKTOP-GG1BEM8
	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\Gerry Mildenberger\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:\WINDOWS\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Gerry Mildenberger\AppData\Local\Microsoft\WindowsApps;C:\Users\Gerry Mildenberger\.dotnet\tools
	USERNAME = Gerry Mildenberger
	OneDrive = C:\Users\Gerry Mildenberger\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-GG1BEM8
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 158 Stepping 10, GenuineIntel
	OneDriveConsumer = C:\Users\Gerry Mildenberger\OneDrive
	USERDOMAIN = DESKTOP-GG1BEM8
	SystemDrive = C:
	TEMP = C:\Users\Gerry Mildenberger\AppData\Local\Temp
	ProgramFiles = C:\Program Files
	VS160COMCOMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\Tools\
	NUMBER_OF_PROCESSORS = 6
	ComSpec = C:\WINDOWS\system32\cmd.exe
	TMP = C:\Users\Gerry Mildenberger\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	PROCESSOR_REVISION = 9e0a
	PUBLIC = C:\Users\Public
19:41:51 [INF][      Workbench]: Current version given by meta info is: 8.0.22
19:41:51 [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:\WINDOWS\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Gerry Mildenberger\AppData\Local\Microsoft\WindowsApps;C:\Users\Gerry Mildenberger\.dotnet\tools
19:41:51 [INF][ mforms managed]: Initializing mforms wrapper
19:41:51 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0
	user data dir: C:\Users\Gerry Mildenberger\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
19:41:51 [INF][      WBContext]: WbContext::init
19:41:51 [INF][            WBA]: Looking for extension modules for WBA...
19:41:51 [INF][            WBA]: 0 extension modules found
19:41:51 [WRN][            grt]: C:\Users\Gerry Mildenberger\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{1DBC097C-B22B-40F4-BA77-20D1918A5908}' <object GrtObject> key=owner could not be resolved
19:41:52 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.22 CE build 107600 (64 bit)
	Configuration Directory: C:\Users\Gerry Mildenberger\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Enterprise
	CPU: 6x Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz, 3.9 GiB RAM
	Active video adapter Intel(R) UHD Graphics 630
	Installed video RAM: 1024 MB
	Current video mode: 1680 x 1050 x 4294967296 colors
	Used bit depth: 32
	Driver version: 26.20.100.7642
	Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_518f2921ba495409\igdumdim64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_518f2921ba495409\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_518f2921ba495409\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_518f2921ba495409\igd12umd64.dll
	Current user language: English (United States)

19:41:52 [INF][      Workbench]: UI is up
19:41:52 [INF][      Workbench]: Running the application
19:41:58 [INF][   WBContext UI]: Opening Migration Wizard...
19:41:58 [WRN][         mforms]: Resource file not found: migration_win.png
19:41:58 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 8.0/modules/data\msaccess_rdbms_info.xml:8: link 'com.mysql.rdbms.msaccess.driver.odbc' <object > key=defaultDriver could not be resolved
19:41:58 [WRN][            grt]: in com.mysql.rdbms.sql92.driver.odbc_dsn: unserialized XML contains invalid member db.mgmt.PythonDBAPIDriver::accessibilityNameLoaded 0/0 new non-MySQL connections
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:41:58 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
19:42:33 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Unable to connect to localhost
19:42:33 [WRN][SQL Editor Form]: Unable to connect to localhost
19:42:33 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
19:42:33 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
19:42:34 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
19:42:34 [INF][        WQE.net]: Launching SQL IDE
19:42:34 [INF][        WQE.net]: SQL IDE UI is ready
19:42:36 [ERR][wb_admin_control.py:init:307]: Error connecting to MySQL: Unable to connect to localhost (code 2003)
19:42:37 [ERR][wb_admin_control.py:get_config_options:760]: Could not open the file "C:\ProgramData\MySQL\MySQL Server 5.5\my.ini": [Errno 2] No such file or directory: 'C:\\ProgramData\\MySQL\\MySQL Server 5.5\\my.ini'
19:42:37 [INF][wb_admin_control.py:query_server_installation_info:860]: Currently connected to MySQL server version 'unknown', conn status = None, active plugins = []
19:42:39 [ERR][wb_admin_control.py:server_polling_thread:561]: Error creating SQL connection for monitoring: MySQLError('Unable to connect to localhost (code 2003)',)
19:42:50 [ERR][wb_admin_control.py:server_started_event:484]: Error connecting to MySQL: Access denied for user 'root'@'localhost' (using password: YES)
19:43:24 [INF][        WQE.net]: Shutting down SQL editor (Local instance)
20:07:32 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
20:07:32 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
20:07:41 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
20:07:41 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
20:07:41 [ERR][    WQE backend]: Got an exception during connection: Access denied for user 'root'@'localhost' (using password: YES)
20:07:41 [ERR][SQL Editor Form]: SQL editor could not be connected: Access denied for user 'root'@'localhost' (using password: YES)
20:07:41 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at 127.0.0.1:3306:
  Access denied for user 'root'@'localhost' (using password: YES)

Please:
1 Check that MySQL is running on address 127.0.0.1
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 127.0.0.1 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 127.0.0.1 connecting from the host address you're connecting from

Suggested fix:
? maybe finding what worked in Workbench 8.0.12.0
or
contact me and link into my computer to fix it
[25 Dec 2020 4:49] Gerry Mildenberger
may have .\binlog.index missing
do not know how to repair or replace
[25 Dec 2020 13:18] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on Windows 10 Pro, MySQL Server 8.0.22, WorkBench 8.0.22 and mysql.exe client also.
[26 Dec 2020 18:40] Gerry Mildenberger
Also both MySQL Command Line Client & MySQL Command Line Client - Unicode will not start
And, both Start ChangeLog and one of the Documentation start buttons wont work.

In Services MySQL does not start. I can start it with mysqld --install, mysqld --initialize but I still cannot connect.
[26 Dec 2020 18:42] Gerry Mildenberger
Also both MySQL Command Line Client & MySQL Command Line Client - Unicode will not start
And, both Start ChangeLog and one of the Documentation start buttons wont work.

In Services MySQL does not start. I can start it with mysqld --install, mysqld --initialize but I still cannot connect.

***Could you at sometime call me, access my computer, and check this please.