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.
Step 2This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.
Step 3 In the top left corner, you’ll see an entry with your account username. Click the “plus sign” to its left.
Step 4 You’ll now see a list of databases in your account. Click the one 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.