# Connecting with phpMyAdmin

phpMyAdmin is a widely used web-based interface for MySQL that allows you to manage databases, run SQL queries, and administer users through a graphical interface.

### **Variables**

To connect using phpMyAdmin, you’ll need the following connection parameters. When you deploy a MySQL service on Elestio, you also get a phpMyAdmin dashboard configured for you to use with these variables. These details are available in the Elestio service overview page:

<table border="1" id="bkmrk-variable-description" style="width: 58.4524%; height: 122.984px; border-collapse: collapse; border-color: rgb(0, 0, 0);"><thead><tr style="height: 29.7969px;"><th style="width: 20.813%; height: 29.7969px; border-color: rgb(0, 0, 0);">**Variable**

</th><th style="width: 32.8605%; height: 29.7969px; border-color: rgb(0, 0, 0);">**Description**

</th><th style="width: 46.3265%; height: 29.7969px; border-color: rgb(0, 0, 0);">**Purpose**

</th></tr></thead><tbody><tr style="height: 46.5938px;"><td style="width: 20.813%; height: 46.5938px; border-color: rgb(0, 0, 0);">**USER**

</td><td style="width: 32.8605%; height: 46.5938px; border-color: rgb(0, 0, 0);">phpMyAdmin username

</td><td style="width: 46.3265%; height: 46.5938px; border-color: rgb(0, 0, 0);">Identifies the database user.

</td></tr><tr style="height: 46.5938px;"><td style="width: 20.813%; height: 46.5938px; border-color: rgb(0, 0, 0);">**PASSWORD**

</td><td style="width: 32.8605%; height: 46.5938px; border-color: rgb(0, 0, 0);">phpMyAdmin password

</td><td style="width: 46.3265%; height: 46.5938px; border-color: rgb(0, 0, 0);">Authentication key for the `USER`.

</td></tr></tbody></table>

You can find these values in your Elestio project dashboard under the Admin section.

[![image.png](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/7dpimage.png)](https://docs.elest.io/uploads/images/gallery/2025-04/7dpimage.png)

### **Prerequisites**

Make sure the MySQL service is correctly deployed on Elestio and you are able to access the Admin section where phpMyAdmin is listed, similar to the example shown in the image above.

### **Setting Up the Connection**

Launch phpMyAdmin using the Admin UI URL and log in with the credentials acquired from the Elestio service dashboard. Once the login screen is loaded, enter the following:

- **Username**<span class="s1">: USER</span>
- <span class="s1">**Password**</span>: PASSWORD

Click on <span class="s2">**Go**</span> to access the phpMyAdmin interface.

[![Screenshot 2025-04-25 at 1.46.40 PM.jpg](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/screenshot-2025-04-25-at-1-46-40-pm.jpg)](https://docs.elest.io/uploads/images/gallery/2025-04/screenshot-2025-04-25-at-1-46-40-pm.jpg)

Once logged in, you can see your available databases listed in the left panel. From here, you can:

- Run SQL queries through the **SQL** tab

[![Screenshot 2025-04-25 at 1.47.07 PM.jpg](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/screenshot-2025-04-25-at-1-47-07-pm.jpg)](https://docs.elest.io/uploads/images/gallery/2025-04/screenshot-2025-04-25-at-1-47-07-pm.jpg)

- View or modify table structures

[![image.png](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/9Rbimage.png)](https://docs.elest.io/uploads/images/gallery/2025-04/9Rbimage.png)

- Export or import database backups

[![Screenshot 2025-04-25 at 2.00.28 PM.jpg](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/screenshot-2025-04-25-at-2-00-28-pm.jpg)](https://docs.elest.io/uploads/images/gallery/2025-04/screenshot-2025-04-25-at-2-00-28-pm.jpg)

- Manage users and privileges if applicable[![image.png](https://docs.elest.io/uploads/images/gallery/2025-04/scaled-1680-/76Fimage.png)](https://docs.elest.io/uploads/images/gallery/2025-04/76Fimage.png)