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