Title: phpMyAdmin in cPanel  
PrimaryCategory: Hosting  
Type: Hybrid  
Tags: phpMyAdmin, database_management, MySQL, cPanel, SQL_query, gui  
Source UI Terms: phpMyAdmin link, databases section, cPanel Home, SQL, Go  
Source Reference: phpMyAdmin in cPanel  

---

### Key Info / Component Reference:

phpMyAdmin is a third-party graphical user interface tool used to manage MySQL databases. It allows users to create tables, import and export data, and edit individual row values within databases. The interface displays a list of databases on the left pane and general database server information on the right pane.

You access phpMyAdmin by clicking the phpMyAdmin link located under the Databases section in the cPanel Home interface.

---

### Procedure: Execute an SQL Query

Steps:  
1) Select the desired database from the left-hand pane by clicking on its name. The database structure will then display.  
2) Click the **SQL** tab on the top bar to open the SQL editor interface.  
3) Enter your SQL query into the editor. You may enter multiple queries separated by semicolons (;).  
4) Click the **Go** button to execute the query. A success message will appear if the query executes without errors.

---

### Summary:

phpMyAdmin in cPanel provides a graphical interface to manage MySQL databases, including creating tables and running SQL queries. You access it from the Databases section in cPanel, select a database, enter your query in the SQL editor, and execute it by clicking Go.

---

### Evaluation Pairs:

Q: How do I access phpMyAdmin in cPanel?  
A: Click the phpMyAdmin link found under the Databases section on the cPanel Home page.

Q: What is the first step to run an SQL query in phpMyAdmin?  
A: Select the database by clicking its name in the left pane.

Q: Can I run multiple SQL queries at once in phpMyAdmin?  
A: Yes, you can enter multiple queries separated by semicolons in the SQL editor.

Q: What indicates that an SQL query was successful in phpMyAdmin?  
A: A success message appears after clicking the Go button and executing the query.

The phpMyAdmin is a third-party tool to manage tables and data inside a database. It is graphical user interface to manage MySQL databases. You can manually create Tables, Import and Export data or edit the values of a row through it.
To access phpMyAdmin, click on the phpMyAdmin link, which can be found under the databases section of cPanel Home.
<img src="https://endurance.my.salesforce.com/file-asset-public/DBpng?oid=00D36000000qEW6" alt="" title="" width="878" height="197"></img>
You will see a dashboard similar to this.
<img src="https://endurance.my.salesforce.com/file-asset-public/PHPMYpng?oid=00D36000000qEW6" alt="" title="" width="885" height="401"></img>
On the left-hand pane, there is a list of databases that can be expanded to view the tables in each database. On the right-hand pane, general information about the database server is displayed.
<h3> Execute an SQL Query</h3>
To run an SQL query on a database, follow the steps below:
Step 1 − Select the database from left pane by clicking over the name of the database. Once the database is selected, it will show you the structure of the database. <img src="https://endurance.my.salesforce.com/file-asset-public/ADMINpng?oid=00D36000000qEW6" alt="" title="" width="869" height="514"></img> 
Step 2 − Click on SQL from top bar to open SQL editor.
<img src="https://endurance.my.salesforce.com/file-asset-public/SQLpng?oid=00D36000000qEW6" alt="" title="" width="857" height="473"></img>
Step 3 − Write your query into the SQL editor. You can also enter multiple queries, separated by semicolon (;).
<img src="https://endurance.my.salesforce.com/file-asset-public/SQLQYpng?oid=00D36000000qEW6" alt="" title="" width="712" height="355"></img>
Step 4 − Click Go button to execute the query. If the query is executed successfully, you will get a success message.