Logo Questions Linux Laravel Mysql Ubuntu Git Menu

How to connect to remote MySQL server via SSH using JPA?






I'm trying to connect to a remote MySQL server via SSH in my Java project. How can I integrate SSH connection with JPA?

I'm using Netbeans 6.9.1, JPA, MySQL 5.2.

like image 832
overstar Avatar asked Feb 26 '23 04:02


1 Answers

I assume you want to tunnel to a remote mysql which only listens to localhost (or is firewalled)

The easiest way is then

  1. setup a trust relationship between the account running the application server providig the JPA service to your application

  2. create the tunnel using ssh -L 3306:localhost:3306 mysql.server.org to create a tunnel which will connect port 3306 on the appservers host to port 3306 on the mysql server's localhost port.

  3. Configure JPA to connect to localhost:3306

like image 188
Peter Tillemans Avatar answered Mar 08 '23 02:03

Peter Tillemans