Database access via GUI

Using a database graphical user interface has many benefits: Visually browse and edit the database, get hints running queries, save connection details as bookmarks. It's also practical to have the client connect to the remote and to the local database. See our database integration section with specific guides for Sequel Ace, Workbench and others.

# General instructions

fortrabbit requires database connections via SSH tunnel. All MySQL clients support this configuration, typically through a dedicated SSH tunnel tab.

• SSH part
  • SSH Host: ssh.{{region}}.frbit.app
  • SSH User: {{app-env-id}}
  • SSH Keyfile: Your local SSH private key
• MySQL part
  • MySQL Host: mysql
  • MySQL Server Port: 3306
  • Username: {{app-env-id}}
  • Password: Look it up in the dashboard
  • Default Schema: {{app-env-id}}

# Next steps

• Database up via GUI
• Database down via GUI

# Troubleshooting

The most common issues setting up the remote connection via database GUI are:

• Using no tunnel. Connect via SSH tunnel.
• Using localhost. Hostname is mysql.