lagodoy Posted February 2, 2021 Share Posted February 2, 2021 hello, please i need help with java connection to my mysql database.what would the connection string look like? I've tried different ways but I didn't succeed,thank you for your help Link to comment Share on other sites More sharing options...
Krydos Posted February 3, 2021 Share Posted February 3, 2021 "jdbc:mysql://65.19.141.67:3306/lagodoy_db?user=lagodoy_user&password=youllneverguessthisone" Link to comment Share on other sites More sharing options...
lagodoy Posted February 4, 2021 Author Share Posted February 4, 2021 Thanks for the feedback, I am using it as you instructed me above, but it is giving access denied error (Access denied for user 'lagodoy_myuser' @ 'my ip' (using password: YES). however the user has a registered password and I am informing it in the connection string the correct password. Link to comment Share on other sites More sharing options...
Luigi123 Posted February 4, 2021 Share Posted February 4, 2021 Make sure you enabled remote mySQL by clicking the button labeled "Remote MySQL" in cpanel and then entering your ip address or putting % to allow all ips to connect Link to comment Share on other sites More sharing options...
lagodoy Posted February 5, 2021 Author Share Posted February 5, 2021 Luigi123, thank you very much for the feedback, I don't know if I didn't understand or if it is because the changes are not made on time and you need to wait some time, but I already had remote mysql active, there was already an IP number I was using, then I put my external ip, then I put my nons dns, then I just put%, I also tried part of the external ip with%, and it continues with the same error. I don't know how to put it anymore. Link to comment Share on other sites More sharing options...
Luigi123 Posted February 5, 2021 Share Posted February 5, 2021 Okay, we will have to wait for Krydos to see if he has more ideas of this issue. Escalating Link to comment Share on other sites More sharing options...
lagodoy Posted February 5, 2021 Author Share Posted February 5, 2021 Luigi123 / Krydos, thanks for the help, I managed to solve it, looking a little bit I saw that I had not given the user privileges to the database. Link to comment Share on other sites More sharing options...
Luigi123 Posted February 5, 2021 Share Posted February 5, 2021 Great! Let us know if you have any questions about this or need anymore help. Link to comment Share on other sites More sharing options...
Recommended Posts