The phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats.

Manage a database with phpMyAdmin

Step 1 Click the “phpMyAdmin” icon.
Go to Database section and click phpMyAdmin

Go to Database section and click phpMyAdmin.

 

Step 2This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.
This is the phpMyAdmin main page.

This is the phpMyAdmin main page.

 

Step 3 In the top left corner, you’ll see an entry with your account username. Click the “plus sign” to its left.
Click plus sign.

Click plus sign.

 

Step 4 You’ll now see a list of databases in your account. Click the one you want to manage.
Click the database you want to manage.

Click the database you want to manage.

 

Step 5 You can now start managing your database. You can manage tables, add or delete entries, and perform queries among other things.
Now you can start managing your database.

Now you can start managing your database.

 

Tagged in:

, ,