MySQL Empty Database / Delete or Drop All Tables in Categories AIX, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, OpenBSD, RedHat and Friends, Solaris-Unix, Suse, Ubuntu Linux, UNIX last updated November 13, 2008Q. How do I empty MySQL database? What SQL command needs to be executed in order to delete all (100s) of tables in MySQL database called atomstore?