Use SSH tunnel connect database
- Select database type:
- Click “New Connection” or “Connection Manager”
- Select from the list of supported databases (MySQL, PostgreSQL, SQL Server, Oracle, etc.)
- Configure database connection:
- Hostname: Typically enter
127.0.0.1 or localhost
(since it will be forwarded locally via an SSH tunnel) - Port: The local port of the database on the SSH server (e.g., MySQL defaults to 3306)
- Database name
- Username and password
- Hostname: Typically enter
- Configure SSH tunnel:
- Check “Use SSH tunnel” or similar option
- SSH host: SSH server address
- SSH port: Typically 22
- SSH username
- Authentication method:
- Password: Enter SSH password
- Key: Select the private key file (typically in .ppk or .pem format)
- Local Port: The local port SteelSQL will connect to (e.g., 63307)
- Remote Host and Port: The database address on the SSH server (possibly
localhost
) and port - Click “Test Connection” to verify the configuration is correct
- Save the connection configuration after successful verification
Last updated on