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

April 9, 2015 1.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 '127.0.0.1' (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 'host-92-21-23-74.as13285.net' 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: https://dev.mysql.com/doc/refman/5.1/en/adding-users.html

Have another answer? Share your knowledge.