• cPanel Hosting Features

How to manage a MySQL database with phpMyAdmin

The main functionality of phpMyAdmin is to manage your databases.

  1. Click phpMyAdmin under the Databases section in cPanel.

    Doteasy cPanel phpMyAdmin

  2. On the phpMyAdmin interface, you will see a list of your databases on the left panel. Click on the database you want to manage.

    manage database phpMyAdmin

  3. In the new screen you will see a list of the database tables, the allowed actions with them, the number of the records, the storage engine, the collation, the tables’ sizes and the overhead.

    phpMyAdmin database table

    The possible actions you can perform include:

    phpMyAdmin database table action

Browse - Only the tables with existing records can be browsed. When selected, a new window with the records list will be opened.

Structure – When selected, a Structure window will open and you will see the database's table structure.

Search – Using the Search action, you can generate a search query for the chosen table.

Insert – Using the Insert action, you can insert records in your database table.

Empty – The Empty action allows you to empty your database table, removing the data and keeping the empty table.

Drop – The Drop action allows you to delete the whole table and all records stored in it.