This snippet shows you how to drop all tables from database in mysql. Unsing drop database will just delete the database and later you just recreate it with create database query.
Source code viewer
/* This won't reset permissions. */Programming Language: MySQL