Access your MySQL® database with Workbench
Requirements
Scalingo for MySQL® databases are not by default directly available on the Internet. To access it, a solution is to setup an encrypted tunnel.
MySQL® Workbench lets you configure this tunnel. We will guide through the steps to configure the connection to a Scalingo for MySQL® addon through an encrypted tunnel.
Database Configuration
Authentication
The connection data can be found from the SCALINGO_MYSQL_URL
environment
variable of your application.
$ scalingo env | grep SCALINGO_MYSQL_URL
SCALINGO_MYSQL_URL=mysql://my_app_3030:CaUrq1MdUkAzCSEq-1Fg@my-app-3030.mysql.a.osc-fr1.scalingo-dbs.com:30999/my_app_3030
In this case:
- Hostname: my-app-3030.mysql.a.osc-fr1.scalingo-dbs.com
- Port: 30999
- User: my_app_3030
- Password: CaUrq1MdUkAzCSEq-1Fg
- Database: my_app_3030
You first need to select “Standard TCP/IP over SSH” as “Connection Method”. Then, fill the fields accordingly:

Configuring SSH
The “SSH Key File” should target the private key associated to the public key you’ve added in the “SSH” tab on your Scalingo Profile.
The “SSH Username” is always git
.
The “SSH Hostname” and “SSH Port” depends on the region your database is deployed on:
- osc-fr1:
ssh.osc-fr1.scalingo.com
- osc-secnum-fr1:
ssh.osc-secnum-fr1.scalingo.com