Note: Before you proceed, just make sure to backup the database you wish to drop.
- Log into your cPanel.
- From the main cPanel screen, look for the Databases category and then click on the phpMyAdmin.
- This opens the phpMyAdmin. Click on the Databases tab at the top of the page. This lists all the databases on the account. Find the database you want to work with and click on it.
Note: Make sure to choose the right database you wish to drop.
- The next screen lists all the tables in the database. Scroll to the bottom and click on the Check all checkbox.
- Next to the Check All checkbox is a dropdown list of commands. Find and click on the Drop option.
- You will then be presented with a confirmation screen that displays the SQL Query phpMyAdmin will run. Click on the Yes button to confirm and run the query.
- After the query runs, the tables will be removed from the list. You should see a message at the top that says "No tables found in database". This means the database is empty.