Solved

Connecting to MySQL through Workbench

Posted on 2013-12-15
7
500 Views
Last Modified: 2013-12-15
Can someone please help me connect to a mysql database through Workbench? I am successful accessing the Database via terminal but I cant get workbench to connect. User error I am sure. Thanks here is the error i am getting
0
Comment
Question by:johnsonrobbins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39720015
If you are using an SSH Tunnel, you need to point the MySQL hostname at the localhost or the IP address that is relaying the SSH Tunnel.
0
 

Author Comment

by:johnsonrobbins
ID: 39720025
I tried this but it also failed
0
 

Author Comment

by:johnsonrobbins
ID: 39720046
i am not savvy on the server side at all so any help would be awesome!dunno?
0
Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

 
LVL 11

Accepted Solution

by:
Gregory Miller earned 500 total points
ID: 39720057
Ahhh... Missed this

Remove the 3306 reference in the SSH Server designation

Well, I just looked at the second screen cap and you have removed it...

Hmm... Still looking...
0
 

Author Closing Comment

by:johnsonrobbins
ID: 39720069
Thanks, i got it... you helped point me in the right direction
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39720129
What was it, if I may ask...?
0
 

Author Comment

by:johnsonrobbins
ID: 39720458
I used the public IP and password instead of the remote "www" one and it worked. I don't understand why I had to do it that way...
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question