# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.readymage.com/application-management/ssh-access/database-access-using-graphical-interface.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.