Skip to content

Instantly share code, notes, and snippets.

@fabiomaggio

fabiomaggio/mysql-ssh-tunnel

Created October 29, 2014 00:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fabiomaggio/c2d739b027183238f9b9 to your computer and use it in GitHub Desktop.
Save fabiomaggio/c2d739b027183238f9b9 to your computer and use it in GitHub Desktop.
Download ZIP
Setup SSH tunnel for MySQL connection in HeidiSQL
Raw
mysql-ssh-tunnel
1. Create SSH tunnel with following command: ssh -L 3307:localhost:3306 user@host
2. Use the following settings in HeidiSQL:
- Hostname: localhost
- User: mysqluser
- Password: mysqluser password
- Port: 3307
Another method is described here: http://www.mattmuller.info/2011/04/remote-mysql-with-heidisql-and-plink/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment