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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.