SSH Forwarding

From Nuclear Physics Group Documentation Pages
Revision as of 16:17, 25 December 2016 by Maurik (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

To access web interfaces on other systems, use SSH port forwarding, like so:

ssh -L [localport]:foreign-system:[foreignport] tunnel-system

This makes a connection yourmachine:localport <-> <tunnel-system> <-> foreign-system:foreignport

So, from your local system to open a mysql connection to "roentgen", use:

 ssh -L 33306:roentgen:3306

You can now use mysql as if it is running locally on port 33306:

 mysql -P 33306 -h -p

Note: yes, you must use -h, or else mysql will try /tmp/mysql.sock and fail to connect, since it is trying your locally running mysqld.

Note: In order to forward privileged ports, you need root access. SO DON'T!