Drop all tables in MySQL database without recreating them

Use the following tip to drop all tables in a database:

mysqldump -uusername -ppassword -hhost \
--add-drop-table --no-data database | grep ^DROP | \
mysql -uusername -ppassword -hhost database

Much easier than have to drop a database, recreate it, and then grant privileges again.