I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is what connection string do I use?
I have my application reading MySQL and Microsoft SQL Server databases on a hospital network. Outside the hospital, the user first needs to get behind the hospital firewall and then my application can give a connection string and attach to the database and make queries. My feeling is the phpMyAdmin does the job of getting behind the firewall, but I then need to know what string format I need to attach to the database. Perhaps there is something else and not phpMyAdmin which I should be using instead? I have no problem working inside the phpMyAdmin GUI on the browser, but I want to work in my own application. How do I do such a thing? Can phpMyAdmin even handle such a case?
Any suggestions would be greatly appreciated. Ilan