Over a million developers have joined DZone.

Connect to MySQL via SSH

· Integration Zone

Is iPaaS solving the right problems? Not knowing the fundamental difference between iPaaS and dPaaS could cost you down the road. Brought to you in partnership with Liaison Technologies.

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.

Discover the unprecedented possibilities and challenges, created by today’s fast paced data climate and why your current integration solution is not enough, brought to you in partnership with Liaison Technologies.

Topics:

Published at DZone with permission of John Whish, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}