Description:
When I try to open the sql editor it gets stuck on "Opening SQL Editor". If I click cancel it keeps trying to connect which uses alot of CPU power as well. I cannot visually see my database at all and it poses a big problem for me.
I am using this for school and it is very important for me.
Please advise on how to fix.
Here is the copy of the LOG file:
11:05:27 [INF][ Workbench]: Starting up Workbench
11:05:27 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /Applications/MySQLWorkbench.app/Contents/Resources
plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
user data dir: /Users/sai/Library/Application Support/MySQL/Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
11:05:27 [INF][ WBContext]: WbContext::init
11:05:27 [INF][ WBA]: Looking for extension modules for WBA...
11:05:27 [INF][ WBA]: 0 extension modules found
11:05:28 [WRN][ grt]: /Users/sai/Library/Application Support/MySQL/Workbench/connections.xml:18: link '444A7224-75DD-49EB-A971-F0AEFFD0A22D' <object GrtObject> key=owner could not be resolved
11:05:28 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for macOS version 8.0.21 CE build 16448441 (64 bit)
Configuration Directory: /Users/sai/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: macOS 10.15.x Catalina x86_64
CPU: 8x Intel(R) Core(TM) i5-8257U CPU @ 1.40GHz - 8.00GiB RAM
No video adapter info available
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_sakila_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_manage_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_folder@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_network_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_plus_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_user_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_plus_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_doc_sql@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_number_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_close@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_open_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_more_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_sakila_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_manage_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_folder@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_network_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_plus_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_user_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_plus_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_doc_sql@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_number_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_close@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_open_dark@2x.png
11:05:28 [WRN][ mforms]: Resource file not found: wb_tile_more_dark@2x.png
11:06:55 [WRN][ mforms]: Resource file not found: MySQL-WB-about-screen@2x@2x.png
11:08:23 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
Thanks,
Sai
How to repeat:
Install up-to-date version and try opening the local instance on the Mac. It will get stuck.