How to clear all tables from a MySQL database.

Sometimes you may be in a situation where you need to clear out a database with out actually deleting the database, Maybe the database is on a hosted service that doesn’t allow you root access, or they do not give you phpMyAdmin access (By the way don’t ever use that!). Β I actually ran into this very scenario, so I need to figure out a fast way to nuke the database from the Linux command line, with out root access. So I wrote this little shell script to do the job for me.