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.
