Question

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

Posted April 9, 2015 7.8k views
MySQL PHP DigitalOcean 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")

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.

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

Submit an Answer