[email protected] | 3F Hanston Bldg., Ortigas Center, Pasig City | +632 8876-1925 |
| | |
iManila Help Center

cPanel – 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.

You will see a dashboard similar to this.

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.

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

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

 

Leave a Reply

Recent Articles

Top 5 Reasons Why Software Updates Are Important for Cybersecurity

Top 5 Reasons Why Software Updates Are Important for Cybersecurity

In today's world, where almost everything happens online, web security is of utmost importance. Whether for businesses or individuals, protecting…

Read more

Is Web Development and Digital Marketing a Good Combo?

Is Web Development and Digital Marketing a Good Combo?

Having just a website isn't enough if you want to increase your online presence. It's like building a beautiful house…

Read more

How To Build a Robust E-Commerce Site with iManila

How To Build a Robust E-Commerce Site with iManila

In today's digital age, where every click translates into a potential sale, the success of your business hinges on the…

Read more

Let's work together!


Make the first move! Let iManila help you maximize your presence online.

Just fill out your contact details and tell us what you need, then we’ll be sure to get back to you as soon as possible.