MySQL Bugs: #80852: Workbench Does not Connect to the Data Base

Bug #80852	Workbench Does not Connect to the Data Base
Submitted:	24 Mar 2016 15:37	Modified:	27 Apr 2016 23:43
Reporter:	ajay penumarthy	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3	OS:	Windows (Microsoft Windows Server 2012 R2 Standard)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\ajay.penumarthy\AppData\Roaming\MySQL\Workbench\log\wb.log]

**************************LOG***************************************
08:24:36 [ERR][      Workbench]: Console redirection failed.
08:24:36 [INF][      WBContext]: Parsing application arguments.
08:24:36 [INF][      WBContext]:     C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
08:24:36 [INF][      Workbench]: Starting up Workbench
08:24:36 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: 1110169937
	UserInteractive: True
	Version: 4.0.30319.34209
	WorkingSet: 30994432

08:24:37 [INF][    WQE backend]: Found auto-save workspace C:\Users\ajay.penumarthy\AppData\Roaming\MySQL\Workbench\sql_workspaces\-1.autosave
08:24:37 [INF][      Workbench]: UI is up
08:24:37 [INF][      Workbench]: Running the application
08:24:38 [ERR][      SqlEditor]: SQL editor could not be connected: Could not open database
08:24:38 [ERR][      SqlEditor]: Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Could not open database

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the 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
08:25:04 [ERR][      SqlEditor]: SQL editor could not be connected: Could not open database
08:25:04 [ERR][      SqlEditor]: Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Could not open database

How to repeat:
Try to open the Database from the Workbench

Please attach screen-shot of the screen of manage connection when you are trying to test the connection. Thanks.

Error Screen Shot

Attachment: MySQL_WorkBench_error.jpg (image/jpeg, text), 76.35 KiB.

Hi,

I have added the Screen Shot for the error.
Thank you,
Ajay

Thank you for the feedback. Are you checked if the server is running?. If yes right click over the connection and select edit connection, press test connection and provide the password if asked. Thanks.

Test Connection Successful

Attachment: MySQL_WorkBench_error_1.jpg (image/jpeg, text), 120.33 KiB.

Hi,

I had already tried this out.. I can see the successful connection.. I can connect to tables and access through the windows command line also.. I am not able to do it with Workbench..

Thank you,
Ajay

If you change the hostname to localhost works?. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".