How to reset/drop my database in phpMyAdmin?

Note: Before you proceed, just make sure to backup the database you wish to drop.

How do I export a MySQL Database? 

  1. Log into your cPanel.
  2. From the main cPanel screen, look for the Databases category and then click on the phpMyAdmin.
  3. 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.

  4. The next screen lists all the tables in the database. Scroll to the bottom and click on the Check all checkbox.
  5. Next to the Check All checkbox is a dropdown list of commands. Find and click on the Drop option.
  6. 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.
  7. 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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon in the "Databases" category....

How do I delete a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

How do I remove a MySQL user from a database?

Login to cPanel. Locate and click on the "MySQL Databases" icon within the "Databases"...

How do I delete a MySQL user?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

How do I add a user to a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...