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

Posted April 7, 2015 8.8k views


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!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
3 answers

Because MySQL binds to localhost by default.

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

Thank you for your help!