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.
You will see a dashboard similar to this.
On the left-hand pane, there is a list of databases, which can be expanded to see the table in each database. On the right-hand pane, there is general information about the 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 the 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 the top bar to open the SQL editor.
Step 3 − Write your query into the SQL editor. You can also enter multiple queries, separated by a semicolon (;).
Step 4 − Click the Go button to execute the query. If the query is executed successfully, you will get a success message.