Why can I access my database via ssh and phpmyadmin but not mysql workbench?

April 7, 2015 5.9k

MySQL DigitalOcean

By:

frenchuser11

Hi,

I have set up a server to host my mysql database in and can successfully connect to it using ssh and phpmyadmin.

However I am having trouble trying to connect it in mysql workbench and I really don't understand where I am going wrong.... Could somebody help?

I am able to create databases using the terminal etc but as soon as I want to connect to it using netbeans or mysql workbench it is failing.!

Would be very grateful for any help as I am new to this...

Thank you!

3 Answers

Woet April 8, 2015

Because MySQL binds to localhost by default.

frenchuser11 April 8, 2015

so how do I connect to my database using mysql workbench?
Woet April 8, 2015

By making it bind to your external IP. I also recommend using SSL, since it's a plaintext protocol.
frenchuser11 April 8, 2015

I have binded it to my external IP ... it is still not letting me connect to it remotely...

I did
sudo nano /etc/mysql/my.cnf

and found bind-address and changed that to the IP i am using...

I dont know where i am going wrong.. am i missing a step?

frenchuser11 April 8, 2015

[deleted]

frenchuser11 April 9, 2015

I have sorted this... there was an issue with the firewall and permissions set for users in the database!

Thank you for your help!

Have another answer? Share your knowledge.

Share