hostimul
All articles
Databases

How to empty a MySQL database using phpMyAdmin?

1. Go to cPanel > Databases section > phpMyAdmin menu:

How to empty a MySQL database using phpMyAdmin? — screenshot 1

2. Select the database you wish to empty. On the left you will see a list with all the database tables (you may have just one database if only one website is hosted):

How to empty a MySQL database using phpMyAdmin? — screenshot 2

3. Choose to Check All to > select all tables > choose the Drop option from the with a selected drop-down list:

How to empty a MySQL database using phpMyAdmin? — screenshot 3

4. The Drop Table SQL will empty all the tables at once. By clicking the Yes button confirm your wish:

How to empty a MySQL database using phpMyAdmin? — screenshot 4