With the following in the config file,
ssh orion will connect to the server:
Host orionUser scottHostName orion.devIdentityFile ~/.ssh/id_rsa
Example: a remote database server (
orion.dev:3306) only allows local access. On local machine we have a GUI tool, which can't connect to the remote database directly.
Solution: On local machine, use the following line to connect local port 9000 with server's port 3306 (via localhost:22, the port SSH uses). Note that the
localhost in the following line refers to the remote server.
Then the GUI tool can connect to
localhost:9000 to access the remote database.