> For the complete documentation index, see [llms.txt](https://help.readymage.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.readymage.com/application-management/ssh-access/database-access-using-graphical-interface.md).

# Database Access using Graphical Interface

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

### macOS <a href="#macos" id="macos"></a>

#### 1. Configure SSH Access <a href="#id-1.-configure-ssh-access" id="id-1.-configure-ssh-access"></a>

Follow [this guide](/application-management/ssh-access.md) to set up SSH access.

#### 2. Get database connection details <a href="#id-2.-get-database-connection-details" id="id-2.-get-database-connection-details"></a>

After making a successful SSH connection use this command:

`cat .my.cnf`

Note the following details

* host
* user
* password

#### 3. Setup Sequel Pro <a href="#id-3.-setup-sequel-pro" id="id-3.-setup-sequel-pro"></a>

Visit the [Sequel Pro official website](https://www.sequelpro.com/) to set it up.

#### 4. Configure Database Connection <a href="#id-4.-configure-database-connection" id="id-4.-configure-database-connection"></a>

![](/files/DdWcgvG0F0eMZ6jYCftq)

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`&#x20;
  * 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](/application-management/ssh-access.md)
* 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](https://help.readymage.com/user-portal/ssh-access) 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](https://dev.mysql.com/downloads/workbench/). Setup instructions for [Linux](https://linuxhint.com/installing_mysql_workbench_ubuntu/) and [Windows](https://dev.mysql.com/doc/workbench/en/wb-installing-windows.html).

#### **4. Configure Database Connection**

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

<figure><img src="/files/bLSmx6nymI8iq339Eaqa" alt=""><figcaption></figcaption></figure>

**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​](/application-management/ssh-access.md)
* 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:&#x20;

<figure><img src="/files/HVZFRQ48SIzPNKz7DOzs" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/VIwP6fANZRezkilfjHAQ" alt=""><figcaption></figcaption></figure>