MySQL Empty Database / Delete or Drop All Tables – nixCraft

Method #1: Empty database with root user

In order to use this procedure you must have the drop and create database privilege
(otherwise you will drop database but not able to create it again).
Login as MySQL root or admin user to drop atomstore database:
$ mysql -u root -p

 
Now drop database:
mysql> DROP DATABASE atomstore;


Now create database again:
mysql> CREATE DATABASE atomstore;


Exit and close the session:
mysql> quit





MySQL Empty Database / Delete or Drop All Tables – nixCraft