Can't connect to remote database using netbeans or mysql workbench
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")