Connecting to MySQL through Workbench

Posted on 2013-12-15
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
Question by:johnsonrobbins
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
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.

Author Comment

ID: 39720025
I tried this but it also failed

Author Comment

ID: 39720046
i am not savvy on the server side at all so any help would be awesome!dunno?
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

LVL 11

Accepted Solution

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...

Author Closing Comment

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

Expert Comment

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

Author Comment

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...

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

705 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