mysqlssh通道java_通过ssh连接到mysqlDB（java）

我需要通过ssh连接连接到Mysql RDS DB&＃xff0c;我试过的是打开一个ssh隧道&＃xff0c;然后连接到该数据库&＃xff0c;但它没有用 .

以下是我的代码&＃xff1a;

int lport &＃61; 3306;

String host &＃61; "10.254.64.135";

String rhost &＃61; "localhost";

int rport &＃61; 8000;

String user &＃61; "ubuntu";

String dbuserName &＃61; "someusername";

String dbpassword &＃61; "somepassword";

String dburl &＃61; "jdbc:mysql://somedbhost.us-east-1.rds.amazonaws.com:3306";

String driverName &＃61; "com.mysql.jdbc.Driver";

String driverName2 &＃61; "org.gjt.mm.mysql.Driver";

Session session &＃61; null;

try {

final java.util.Properties config &＃61; new java.util.Properties();

config.put("StrictHostKeyChecking", "no");

final JSch jsch &＃61; new JSch();

session &＃61; jsch.getSession(user, host, 22);

jsch.addIdentity("C:\\Users\\rop\\workspace\\awskey.pem");

session.setConfig(config);

session.connect();

System.out.println("Connected through SSH");

final int assinged_port &＃61; session.setPortForwardingL(rport, host,lport );

System.out.println("localhost:" &＃43; assinged_port &＃43; " -> " &＃43; rhost &＃43; ":" &＃43; rport);

System.out.println("Port Forwarded");

//mysql database connectivity

Class.forName("com.mysql.jdbc.Driver").newInstance();

//String url &＃61; "jdbc:mysql://localhost:" &＃43; rport &＃43; "/" &＃43; db;

con &＃61; DriverManager.getConnection(dburl, dbuserName, dbpassword);

System.out.println("Mysql Database connection established");

System.out.println("DONE");

上面的代码崩溃&＃xff0c;出现以下异常&＃xff0c;并在此行中崩溃“con &＃61; DriverManager.getConnection(dburl&＃xff0c;dbuserName&＃xff0c;dbpassword);”&＃xff1a;

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException&＃xff1a;通信链路故障成功发送到服务器的最后一个数据包是0毫秒前 . 驱动程序未收到来自服务器的任何数据包 .

这意味着当我们从mysql工作台连接时&＃xff0c;它确实正常连接&＃xff0c;在快照下面&＃xff1a;

请注意&＃xff0c;ssh主机ip与db主机ip不同

谢谢 .