How can I empty a MySQL database?


The easiest way to empty a MySQL database is through phpMyAdmin.

Once in phpMyAdmin, select the database you wish to empty.

A list with all the database’s tables will appear. Click [Check All] to select all tables.

Click the box [With selected:] and choose Drop and confirm. This will execute the DROP TABLE SQL query on all tables and the database will be emptied.