Forward local service running on remote to local client in localhost.
mysql -h host -u demo -psecret demo_db # cannot connect directly
ssh -L 13306:127.0.0.1:3306 demo@host # exec on local
mysql -h 127.0.0.1 -P 13306 -u demo -psecret demo_db # exec on local
Expose local service running on localhost to local client in remote.
ssh -R 16379:127.0.0.1:6379 demo@host # exec on local
ssh root@host -p 22 # login into remote
redis-cli -h 127.0.0.1 -p 16379 # exec on remote
ssh -D 1337 demo@host