Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Connect to MySQL via SSH

DZone's Guide to

Connect to MySQL via SSH

· Integration Zone ·
Free Resource

SnapLogic is the leading self-service enterprise-grade integration platform. Download the 2018 GartnerMagic Quadrant for Enterprise iPaaS or play around on the platform, risk free, for 30 days.

I use the excellent HeidiSQL as a GUI when working with MySQL.

I've recently set up a new server and knew that HeidiSQL has support for connecting via an SSH tunnel. As a note to myself, these are the settings:

Settings tab:

Network type: MySQL (SSH tunnel)
Hostname / IP: locahost
User: mysqlusername
Password: mysqluserpassword

SSH tunnel tab:

plink.exe location: c:\somedir\plink.exe
SSH Host: my.server.com
SSH port: 22
Username: mysshuser
Password: mysshpassword

The key thing to note is that on the settings tab you need to enter localhost and the username and password of the MySQL user. This is because HeidiSQL connects to MySQL once you're connected via an SSH login.

With SnapLogic’s integration platform you can save millions of dollars, increase integrator productivity by 5X, and reduce integration time to value by 90%. Sign up for our risk-free 30-day trial!

Topics:

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}