Bug #90707 I am not able to establish connection
Submitted: 30 Apr 2018 23:05 Modified: 4 May 2018 17:14
Reporter: Fareed Sayed Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.10 OS:MacOS (OS X 10.10.x Yosemite x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[30 Apr 2018 23:05] Fareed Sayed
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/hi/Library/Application Support/MySQL/Workbench/log/wb.log]

15:38:02 [INF][      Workbench]: Starting up Workbench
15:38:02 [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/hi/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
15:38:02 [INF][      WBContext]: WbContext::init
15:38:02 [INF][            WBA]: Looking for extension modules for WBA...
15:38:02 [INF][            WBA]: 0 extension modules found
15:38:02 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Mac OS X version 6.3.10 CE build 12092614 (64 bit)
	Configuration Directory: /Users/hi/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.10.2
	OS: OS X 10.10.x Yosemite x86_64
	CPU: 4x Intel(R) Core(TM) i7-3520M CPU @ 2.90GHz - 16.00GiB RAM
No video adapter info available

15:51:17 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (61)
15:51:17 [WRN][SQL Editor Form]: Can't connect to MySQL server on '127.0.0.1' (61)
15:51:17 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:51:17 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:51:17 [INF][  column_widths]: Initializing column width cache for My-New-Connection
15:51:18 [ERR][wb_admin_control.py:init:314]: Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)
15:51:18 [ERR][wb_admin_control.py:server_polling_thread:564]: Error creating SQL connection for monitoring: MySQLError("Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)",)
15:51:18 [ERR][wb_admin_control.py:get_config_options:768]: Could not open the file "/etc/my.cnf": [Errno 2] No such file or directory: '/etc/my.cnf'
15:51:18 [INF][wb_admin_control.py:query_server_installation_info:868]: Currently connected to MySQL server version 'unknown', conn status = None, active plugins = []
15:51:18 [INF][wb_admin_control.py:acquire_admin_access:288]: Target OS detection returned: os_type=darwin, os_name=Mac OS X, os_variant=Mac OS X, os_version=10.10.5
15:51:19 [INF][wb_admin_control.py:exec_query:631]: sql connection is down
15:51:38 [ERR][wb_admin_main.py:shutdown:219]: shutting down admn
15:51:51 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (61)
15:51:51 [WRN][SQL Editor Form]: Can't connect to MySQL server on '127.0.0.1' (61)
15:51:51 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:51:51 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:51:52 [ERR][wb_admin_control.py:init:314]: Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)
15:51:52 [ERR][wb_admin_control.py:get_config_options:768]: Could not open the file "/etc/my.cnf": [Errno 2] No such file or directory: '/etc/my.cnf'
15:51:52 [INF][wb_admin_control.py:query_server_installation_info:868]: Currently connected to MySQL server version 'unknown', conn status = None, active plugins = []
15:51:52 [ERR][wb_admin_control.py:server_polling_thread:564]: Error creating SQL connection for monitoring: MySQLError("Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)",)
15:51:52 [INF][wb_admin_control.py:acquire_admin_access:288]: Target OS detection returned: os_type=darwin, os_name=Mac OS X, os_variant=Mac OS X, os_version=10.10.5
15:51:52 [INF][wb_admin_control.py:exec_query:631]: sql connection is down
15:56:14 [ERR][wb_admin_main.py:shutdown:219]: shutting down admn
15:56:18 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (61)
15:56:18 [WRN][SQL Editor Form]: Can't connect to MySQL server on '127.0.0.1' (61)
15:56:18 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:56:18 [INF][SQL Editor Form]: Error 2003 connecting to server, assuming server is down and opening editor with no connection
15:56:18 [ERR][wb_admin_control.py:init:314]: Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)
15:56:18 [ERR][wb_admin_control.py:server_polling_thread:564]: Error creating SQL connection for monitoring: MySQLError("Can't connect to MySQL server on '127.0.0.1' (61) (code 2003)",)
15:56:18 [ERR][wb_admin_control.py:get_config_options:768]: Could not open the file "/etc/my.cnf": [Errno 2] No such file or directory: '/etc/my.cnf'
15:56:18 [INF][wb_admin_control.py:query_server_installation_info:868]: Currently connected to MySQL server version 'unknown', conn status = None, active plugins = []
15:56:18 [INF][wb_admin_control.py:acquire_admin_access:288]: Target OS detection returned: os_type=darwin, os_name=Mac OS X, os_variant=Mac OS X, os_version=10.10.5
15:56:19 [INF][wb_admin_control.py:exec_query:631]: sql connection is down
15:56:29 [INF][wb_admin_control.py:exec_query:631]: sql connection is down
15:56:32 [ERR][wb_admin_main.py:shutdown:219]: shutting down admn

How to repeat:
Select "Manage Server Connection"  select "Test Connection".  No connection established.  

Suggested fix:
Help Establish connections.
[30 Apr 2018 23:19] MySQL Verification Team
Thank you for the bug report. Which server version are you trying to connect?. Thanks.
[30 Apr 2018 23:41] Fareed Sayed
I am trying to install MySQL and Workbench for the first time.  

Here is the youtube video I followed to install and establish connection.

https://www.youtube.com/watch?v=-TSFLhlGY1k&index=10&list=PLVMZC4CMt5VOozZhnxEOsaVzOu9fEO9...

Thanks,
[30 Apr 2018 23:57] MySQL Verification Team
Thank you for feedback. I need to know the MySQL Server version i.e: 8.0.11, 5.7.22 etc. Thanks.
[1 May 2018 0:04] MySQL Verification Team
Thank you for the feedback. Looking your video you was able to connect.
[4 May 2018 16:55] Fareed Sayed
I got an error when I followed the video.  Is there a way to call or text to start the trouble shoot?  I would like to start using MySQL.. thanks.
[4 May 2018 17:14] Fareed Sayed
This is the error I get. 

"Failed to Connect ot MySQL at 127.0.0.1:3306 with user root.  Can't connect to MYSQL server on 127.0.0.1 (61)"

Please help me connect to the SQL Server.