[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

Summer-Ready Web Design Ideas for Your Business

Summer-Ready Web Design Ideas for Your Business

An impactful online presence is vital for any business looking to stand out in today's competitive marketplace. As we enter…

Read more

Heat Up Your Sales With These Summer Campaign Ideas iManila

Heat Up Your Sales With These Summer Campaign Ideas

Ready to boost your summer sales? The summer season is a golden opportunity for businesses to elevate their marketing strategies.…

Read more

Why Website Backups Are Vital For Your Business

Why Website Backups Are Vital For Your Business

Have you ever stopped to ponder the consequences your business could face if your website suddenly vanished into thin air?…

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.