?
Solved

Connecting to MySQL through Workbench

Posted on 2013-12-15
7
Medium Priority
?
506 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
Give Your Engineering Team a Productivity Boost

Learn why container technology is so powerful and how it can provide your team with productivity gains and other benefits.

 
LVL 11

Accepted Solution

by:
Gregory Miller earned 1500 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

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

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.
Fine Tune your automatic Updates for Ubuntu / Debian
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

777 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