MySQL Server : Open Source Database : Drop Database

• Drop Database
• Drop Database using mysqladmin command
• Examples

DROP DATABASE drops all tables in the database and deletes the database.

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation.

All files having following extension will get deleted.
.BAK .DAT .HSH .MRG .MYD .MYI
.TRG .TRN .db .frm .ibd .ndb

Delete Database from mysqladmin command in MySQL Server

C:\Program Files (x86)\MySQL5.5\bin><b>mysqladmin -u root -p drop javaskool_inventory</b>
Enter password: *****
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'javaskool_inventory' database [y/N] y
Database "javaskool_inventory" dropped

C:\Program Files (x86)\MySQL5.5\bin>

Delete Database from MySQL Server

mysql> <b>drop database javaskool_inventory;</b>
Query OK, 0 rows affected (3.31 sec)

mysql> show databases;