menachemt Posted June 22, 2012 Share Posted June 22, 2012 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! Quote Link to comment Share on other sites More sharing options...
Tjoene Posted June 23, 2012 Share Posted June 23, 2012 Did you set the remote MySQL up in cPanel? Quote Link to comment Share on other sites More sharing options...
menachemt Posted June 24, 2012 Author Share Posted June 24, 2012 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? 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.