When connecting to a database via SSH host (commonly referred as a bastion host or jumpbox), there are a few extra steps. You do not need to connect to your database via SSH. This is optional and for if you want to connect this way.
First follow the instructions found here for connecting your database. You need to:
- Whitelist Grow's IP addresses.
- Create a read-only user.
- Get the connection info like host, database name, username and password, etc.
To connect via SSH you need this additional info:
- SSHHost: The Public IP for the server.
- SSHPort: This is most often port 22.
- SSHUsername: SSH user Username
- SSHPassword: SSH user Password
If you want to use a keyfile instead of a password, you can check Use SSH Key File and then upload your keyfile.
If you are not able to or don't want to connect to your database directly, you can first connect to a server that has SSH access to your server, and Grow will then connect to your database through that server.
If your database is on your SSH server, your database Host would be the private IP address of your server, and your SSHHost would be the server hostname.
Here are some examples of what this would look like: