Connecting to MySQL through Workbench

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
johnsonrobbinsAsked:
Who is Participating?
 
Gregory MillerConnect With a Mentor General ManagerCommented:
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
 
Gregory MillerGeneral ManagerCommented:
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
 
johnsonrobbinsAuthor Commented:
I tried this but it also failed
0
Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

 
johnsonrobbinsAuthor Commented:
i am not savvy on the server side at all so any help would be awesome!dunno?
0
 
johnsonrobbinsAuthor Commented:
Thanks, i got it... you helped point me in the right direction
0
 
Gregory MillerGeneral ManagerCommented:
What was it, if I may ask...?
0
 
johnsonrobbinsAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.