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

April 7, 2015 6.5k views
MySQL DigitalOcean
frenchuser11
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!

Log In to Comment
3 Answers
Woet April 8, 2015

Because MySQL binds to localhost by default.

Reply
  • 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]
Reply
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!

Reply
  • kanax April 25, 2019

    Hello, I face a similar problem. Could you elaborate on the step steps you took?

Have another answer? Share your knowledge.

Related Questions