JDBC over SSH?
843859May 11 2007 — edited May 12 2007I have a shared web hosting plan with a web hosting provider. They provide typical web server, PHP, MySQL, etc as well as the ability to SSH in to my account, but no JVM on the server. I have a web app on that server that stores a bunch of data in MySQL.
I'd like to write a Java app, which I'd run locally on my dev machine, that would use JDBC to connect to the MySQL database on my shared web host. The problem is that the MySQL server, for security reasons, doesn't accept remote connections.
I can SSH to the shared server and access MySQL via command-line. Is there any way to setup an SSH connection that JDBC can use, so I can access that MySQL database remotely?