[Solved] java connection string with mysql

[lagodoy]

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

 

[Krydos]

"jdbc:mysql://65.19.141.67:3306/lagodoy_db?user=lagodoy_user&password=youllneverguessthisone"

[lagodoy]

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.

[Luigi123]

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

[lagodoy]

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.

[Luigi123]

Okay, we will have to wait for Krydos to see if he has more ideas of this issue.

 

Escalating

[lagodoy]

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.

[Luigi123]

Great!

 

Let us know if you have any questions about this or need anymore help.