Can't connect to remote database using netbeans or mysql workbench

April 9, 2015 6.6k views
DigitalOcean MySQL PHP Firewall

Hi everyone,

I would like to connect to my database remotely however, I am only able to access it using phpmyadmin and through my terminal.

I would like to get mysql workbench and netbeans connecting to it but it is failing.

When trying to connect using mysql workbench I get the following error:

Failed to Connect to MySQL at x.x.x.:x through SSH tunnel at x.x.x with user test

Can't connect to MySQL server on '' (61)

When trying to connect to it using Netbeans I get the following :
Cannot establish a connection to jdbc:mysql://x.x.x.x:3306/x?zeroDateTimeBehavior=convertToNull using com.mysql.jdbc.Driver (null,  message from server: "Host '' is not allowed to connect to this MySQL server")

1 Answer

Have you set proper user permissions so your machine can remotely connect to the MySQL server?
I would check that, if not add yourself to the list and set permissions so you can eventually connect.

Heres a detail from the MySQL Documentation:

Have another answer? Share your knowledge.