MySQL Empty Database / Delete or Drop All Tables last updated November 13, 2008 in Categories AIX, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, OpenBSD, RedHat and Friends, Solaris-Unix, Suse, Ubuntu Linux, UNIXQ. 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?