Mysql Connection Problem

[menachemt]

Hello. I have tried connecting to the mysql database externally. I have added a % to the remote mysql. This is the information I am using.

 

<Driver>org.gjt.mm.mysql.Driver</Driver>

<ConnectionString>jdbc:mysql://johnny.heliohost.org:2082/menachem_game</ConnectionString>

 

 

<UserName>menachem_game</UserName>

<Password>xxxxxxx</Password>

 

<TestSQL><![CDATA[sELECT username(*) FROM users]]></TestSQL>

 

This doesn't seem to work when the TestSQL runs. I have tried using localhost and port 3306. The other information is correct. My database and username are the same name. What am I doing wrong? Are the host name and port correct? Thanks!

[Tjoene]

Did you set the remote MySQL up in cPanel?

[menachemt]

As I mentioned, I added a % to the remote mysql. I assume this adds every ip address. I am new to remote mysql. If % doesn't add every ip address, then do i need to add only my ip?