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

April 7, 2015 2.2k views
MySQL DigitalOcean


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

Because MySQL binds to localhost by default.

  • so how do I connect to my database using mysql workbench?

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

  • 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?

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.