How to drop all table in MySQL?

mysql, phpmyadmin

Solution

mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]

Here there are more methods to drop all tables without dropping the database.

Problem

I don't want to drop database, because I'm not hosting the website on my own machine, drop the database will require create it again,and many settings. Is there a command in MySQL that can be used to delete all tables in a specific database? EDIT Everything I can do is within a phpMyAdmin

Original source