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")
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.