padje Posted March 27, 2018 Share Posted March 27, 2018 I am not able to connect to the database remotely. Am I using the right details? Database url string: jdbc:mysql://padje.heliohost.org:3306/padje_spieladb User: Cpanel username Password: Cpanel password I copied the username and password directly from my password manager so I am quite sure that is not the problem.When trying to connect I get this exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Quote Link to comment Share on other sites More sharing options...
wolstech Posted March 28, 2018 Share Posted March 28, 2018 The host name for remote MySQL should be johnny.heliohost.org. Also, remote MySQL needs to be enabled in cPanel first. Quote Link to comment Share on other sites More sharing options...
padje Posted March 28, 2018 Author Share Posted March 28, 2018 The host name for remote MySQL should be johnny.heliohost.org. Also, remote MySQL needs to be enabled in cPanel first.Thank you for your answer, I changed the hostname but I still can not connect. I added the access host "%" and my own public ip to thw access hosts, is that enough to enable the remote MySql? Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 28, 2018 Share Posted March 28, 2018 Yes. Quote Link to comment Share on other sites More sharing options...
dressdoc Posted April 1, 2018 Share Posted April 1, 2018 You are getting this error because you are trying to access the mysql from your local computer. So to enable use of mysql from local computer you need to add a ip address to remote mysql. As remote mysql allow only certain ip address to connect with, by default it is blocked. If you want to allow connection from any ip address, you need to enter a wild card entry. In that case you can use %.%.%.% and save the remote mysql ip. Now try to connect to database. Quote Link to comment Share on other sites More sharing options...
fjmduran Posted September 19, 2018 Share Posted September 19, 2018 Thanks, I have been able to solve my problem connection with this topic Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.