Solved

Connecting to MySQL through Workbench

Posted on 2013-12-15
7
495 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OpenVPN Speed limitation to only 10 mbps 7 140
Could you point why this Codeigniter's data insertion is causing an error? 8 50
centos linux 65 134
mysql date time 14 31
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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 …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

810 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