Database Access using Graphical Interface

You can access the database using a graphical interface that supports SSH connection.

macOS

1. Configure SSH Access

Follow this guide to set up SSH access.

2. Get database connection details

After making a successful SSH connection use this command:

cat .my.cnf

Note the following details

• host

• user

• password

3. Setup Sequel Pro

Visit the Sequel Pro official website to set it up.

4. Configure Database Connection

Enter the following details from the data you got in step 2:

• MySQL Host

• Username

• Password

Other details:

• SSH Host by region:

  • USA Ohio: ssh.ohio.us.i.readymage.com

  • Europe Ireland: ssh.ireland.eu.i.readymage.com

  • Europe Stockholm: ssh.stockholm.eu.i.readymage.com

  • Canada Central: ssh.central.ca.i.readymage.com

  • Middle East UAE: ssh.central.me.i.readymage.com

  • Asia Pacific Sydney: ssh.sydney.ap.i.readymage.com

• SSH Port - 22

• SSH User: copy from User Portal following this guide

• SSH Password: enter only if you have set a password for your SSH when generating it on your computer

Press Connect to connect to your database.

Linux and Windows

1. Configure SSH Access

Follow this guide to set up SSH access.

2. Get database connection details

After making a successful SSH connection use this command:

cat .my.cnf

Note the following details

• host

• user

• password

3. Setup MySQL Workbench

Download available here. Setup instructions for Linux and Windows.

4. Configure Database Connection

Make sure to select Standard TCP/IP over SSH as the Connection Method.

Enter the following details from the data you got in step 2:

• MySQL Host

• Username

• Password

Other details:

• SSH Host by region (port included):

  • USA Ohio: ssh.ohio.us.i.readymage.com:22

  • Europe Ireland: ssh.ireland.eu.i.readymage.com:22

  • Europe Stockholm: ssh.stockholm.eu.i.readymage.com:22

  • Canada Central: ssh.central.ca.i.readymage.com:22

  • Middle East UAE: ssh.central.me.i.readymage.com:22

  • Asia Pacific Sydney: ssh.sydney.ap.i.readymage.com:22

• SSH User: copy from User Portal following this guide​

• SSH Password: enter only if you have set a password for your SSH when generating it on your computer

• SSH Key File: choose your SSH private key file location.

After filling in the connection parameters click Test Connection and you should see the following window:

Click OK, then OK to save your connection settings and your created connection will be available in the MySQL Connections list.