Connection to MYSQL database

KNIME Analytics Platform
#1

Hello All,

I am using MYSQL as my Database which is on secured network port and to access that we required network tunnel to be open. 

I am trying to connect to that MYSQL Db using Database connection node but i am unable to do so.  I tried to use the SSH connection node also still no luck.

 

Can someone help me in this, how to resolve this issue.

Thanks in advance......

Regards

 

#2

How about:

(1) Establish the SSH tunnel on system level (command line)
(2) Connect to the local port via the KNIME node?

-- P.