1. Home
  2. SQL
  3. MySQL Tutorial
  4. MySQL – Drop Database

MySQL – Drop Database

Use DROP statement to delete database using MySQL query prompt. This tutorial will help you to delete MySQL database using the command line.

Syntax:-

DROP database_name;

Example:

Login to your MySQL server using command line. You will get MySQL database prompt like mysql> . Now use following command to connect mydb database.

mysql> DROP mydb;

Another Example:

You can also use the following command directly on operating system command prompt without login to MySQL. This help users to automate task inside a script.

mysqladmin -u root -p drop mydb
Tags , ,
Was this article helpful to you? Yes 1 No
Advertisement