Knowledge Base

113. Tutorial - phpMyAdmin

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.

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 semicolon (;).

Multiple Queries

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

Please rate this article to help us improve our Knowledge Base.

0 0