> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://helpdesk.gbnetwork.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Managing MySQL Databases with PHPMyAdmin

This article provides a comprehensive guide on managing MySQL databases using phpMyAdmin within the cPanel environment. It outlines the essential functions such as creating and modifying databases, executing SQL queries, importing and exporting data, and managing user privileges, allowing you to maintain your database efficiently through a web-based interface.

This guide will walk you through to manage MySQL databases with PHPMyAdmin.

||| **Warning: Modifying phpMyAdmin without careful handling could potentially disrupt your website. It's advisable to consult with your web developer before making any changes in phpMyAdmin.**

1. Login to your **cPanel**.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/cpanel_3wrsvv.png)

2. Initiate a search by using the search bar for **phpMyAdmin**.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/satu_hoy2yq.png)

3. You have successfully access to the phpMyAdmin page.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/voyl7qrl1f_u8ril5.png)

4. Navigate to the **Import** tab, as indicated in the provided image, in order to import data into your database. Click on the **Browse File** option to locate the data you wish to insert into the database.

|| Tips: Make sure the data is in the SQL format.

![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/dua_tnsi2.png)

5. Continuing down the page, you'll discover an **Import **button. Click this button, and your data will be imported into the database.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/keffuhpyt2_15llmh0.png)

6. Locate the **Export tab, as illustrated below, where you can export or download your data to your computer. Simply select the desired database, go to the Export** tab, and click the **Export **button.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/empat_sw7fbl.png)

7. In the phpMyAdmin, you also can create a new table to develop a new function in your website.
![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/4ui3kfvylo_lonndz.png)

8. In the image provided below, you have the option to perform actions for managing your table.

||| Warning: Managing your database with caution to avoid file disruption.

![](https://storage.crisp.chat/users/helpdesk/website/-/6/7/9/3/67938060e89a4400/2suhvjd8pb_gnsryh.png)

| You have successfully managing MySQL Databases with PHPMyAdmin.

---

### Need Further Assistance?

If you face any issues or need assistance, don’t hesitate to reach out — **our support team is always ready to help!**

🔧 **Need help?** [**Submit a Support Ticket**](https://secure.gbnetwork.com/submitticket.php)  
💬 **Chat with us on Live Chat via our** [**website**](https://www.gbnetwork.my/)