# Connection to data base with tunneling ssh

**URL:** <https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379>\
**Category:** Ignition\
**Created:** [August 23, 2018, 12:52pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379 "2018-08-23T12:52:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![crbejaranoh](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@crbejaranoh](https://forum.inductiveautomation.com/u/crbejaranoh)\
**Post date:** [August 23, 2018, 12:52pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379/1 "2018-08-23T12:52:12Z")

</div>

Hi,  
How do I do a connection to data base uses a tunneling ssh?

---

<div class="post-metadata">

**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\
**Post date:** [August 23, 2018, 3:25pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379/2 "2018-08-23T15:25:03Z")

</div>

> [@crbejaranoh](#):
>
> How do I do a connection to data base uses a tunneling ssh?

which database, version and os?

---

<div class="post-metadata">

**Author:** ![crbejaranoh](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@crbejaranoh](https://forum.inductiveautomation.com/u/crbejaranoh)\
**Post date:** [August 23, 2018, 4:23pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379/3 "2018-08-23T16:23:01Z")

</div>

The OS is ubuntu 18.04, the ignition version is 7.9 and the database I am working with is MySql 5.7, is there a way to do it from ignition?  
Thank

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 23, 2018, 4:49pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379/4 "2018-08-23T16:49:24Z")

</div>

The MySQL JDBC driver does not support SSH as a connection protocol (I don’t think any JDBC driver does), so you would need to use an SSH ‘tunnel’ to route traffic from the JDBC driver over SSH to the remote database. See [here](https://stackoverflow.com/questions/1968293/connect-to-remote-mysql-database-through-ssh-using-java) for more information.

---

<div class="post-metadata">

**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\
**Post date:** [August 23, 2018, 5:34pm UTC](https://forum.inductiveautomation.com/t/connection-to-data-base-with-tunneling-ssh/19379/5 "2018-08-23T17:34:15Z")

</div>

> [@crbejaranoh](#):
>
> The OS is ubuntu 18.04, the ignition version is 7.9 and the database I am working with is MySql 5.7, is there a way to do it from ignition?

I have identical setup. I use TCP/IP ssh to connect a remote machine on LAN at 192.168.1.102 from my laptop. This works with Ignition The screenshot of workbench is below.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/20fd9159fa14110dc4a1f7899b7637a75b6870b9.png)