SSH port forwarding for remote database administration

December 02, 2011

It’s not a good idea to set up a phpMyAdmin on your production server mainly because of security reasons. Also if you are running a python only web application then there is no reason to load any PHP modules - they’d just eat memory.

So SSH allows you to forward ports from a remote machine to your local machine so you can access the database as if it was your local deployment without many of the security issues.

ssh -N -L 3306: [email protected]

So this forwards the remote MySQL port to your local machines port 3306 to which you can connect with your favorite administrative tools. Be it phpMyAdmin, Sequel Pro or anything else.


  • -L [bind_address:]port:host:hostport
  • -N Do not execute a remote command.

A blog by Madis Väin
Thoughts on product & software engineering.