Solved

Connecting to MySQL through Workbench

Posted on 2013-12-15
7
494 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
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:Technodweeb
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 11

Accepted Solution

by:
Technodweeb 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:Technodweeb
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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 …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now