cPanel - phpMyAdmin

The phpMyAdmin is a third-party tool to manage tables and data inside a database. It is a 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.

phpMyAdmin Link

You will see a dashboard similar to this.

phpMyAdmin

On the left-hand pane, there is a list of databases, which can be expended to see the table in each database. On the right-hand pane, there is general information of Database server.

Execute an SQL Query

To execute an SQL Query on a database, we will need to perform the following steps −

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.

Step 2 − Click on SQL from top bar to open SQL editor.

SQL Editor

Step 3 − Write your query into the SQL editor. You can also enter multiple queries, separated by a semicolon (;).

Multiple Queries

Step 4 − Click the Go button to execute the query. If the query is executed successfully, you will get a success message.

  • phpMyAdmin, cpanel
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

cPanel - Addon Domain Name

Addon Domains are addition domains hosted in your account, stored in subfolders. System treats...

cPanel - Logging into cPanel

In this chapter, we will learn to login into the cPanel Dashboard. For logging into the...

cPanel - Changing Password

When you are successfully logged into a cPanel Dashboard, first and foremost, change the password...

cPanel - Styles

You can change cPanel’s look and feel using this interface. cPanel has two major interface styles...

cPanel - Contact Information

In this interface of cPanel, you are allowed to change the system email address. It is the email...