Skip to content

Instantly share code, notes, and snippets.

@manashcse11

manashcse11/mysql-remote-db-from-local-ssh-tunneling.md

Last active August 21, 2017 06:02
Show Gist options
  • Save manashcse11/35d3c523075e107d914613c6f19ecc48 to your computer and use it in GitHub Desktop.
Save manashcse11/35d3c523075e107d914613c6f19ecc48 to your computer and use it in GitHub Desktop.
Download ZIP
#mysql #remote-db-from-local # Connect remote mysql using HeidiSQL
Raw
mysql-remote-db-from-local-ssh-tunneling.md

If you can ssh then you can connect with the remote database by ssh tunneling. Open babun & write below command. Also you can add to to alias

ssh -L 3300:localhost:3306 root@107.170.73.134

Then open HeidiSQL -> Session Manager -> New

Hostname: 127.0.0.1

User: dbuser

Password: dbpassword

Port: 3300

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment