I am playing around with db based websites. (I know that dh does not support Java). I am trying to access my mySQL db hosted by dh from a java project on my local machine.
I can access a locally hosted mySQL db with
Connection con = DriverManager.getConnection(“jdbc:mysql//localhost:3306/testdb_2”,“username”, “password”);
How can i access my dh hosted mySQL db (assuming the host name is “mysql.example.com” and the db name is “testdb_2”?
To clarify: I already allowed my computer’s IP address access to the db. I’m asking for the format of the db source string. I tried (“jdbc:mysql//mysql.example.com:3306/testdb_2”,“username”,“password”); but that didn’t work. This is more of a jdbc question specific to dh. I believe all of the configurations on the dh side are already set up.