java.sql.Connection extension for SSH [duplicate]

Question

I have a MySQL database behind a firewall which can only be accessed via an SSH connection. Does anyone know of an implementation of java.sql.Connection which would allow me to make an SSH connection to this database?

Kevin Wright · Accepted Answer · 2012-08-21 14:25:56Z

15

You can use SSH's port forwarding to do this. While not a pure java.sql.Connection, it will allow you to tunnel the connection through ssh.

ssh -L 3306:localhost:3306 remote.mysql.host.com

This will forward port 3306 on your local machine to port 3306 on remote.mysql.host.com. This will allow you to connect to port 3306 on your local machine, and it will be tunnelled to remote.mysql.host.com.

If you're looking to do it all in Java, create the ssh connection with JSch.

edited Aug 21, 2012 at 14:25

Kevin Wright

49.7k9 gold badges107 silver badges156 bronze badges

answered Oct 31, 2008 at 1:37

Steve K

19.6k6 gold badges55 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ripon Al Wasim Over a year ago

How can I establish the connection with MySQL on remote server with Java?

James Newman · Accepted Answer · 2015-03-13 23:52:28Z

0

Here is an example using the library sshj.

answered Mar 13, 2015 at 23:52

James Newman

1715 bronze badges

Collectives™ on Stack Overflow

java.sql.Connection extension for SSH [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related