Edit Article

Edited by Daniel Leblond, Carolyn Barratt, Teresa, Maluniu and 2 others

Simple steps on deleting a MySQL database.

Ad

EditSteps

  1. Delete a MySQL Database Step 1.jpg
    1
    You'll need a user that has super DELETE privileges on the specific database. If you don't have a specific user to do so you can use your root user.
    Ad
  2. Delete a MySQL Database Step 2.jpg
    2
    Using MySQL Command Line Client, go to your terminal view (Command Prompt on Windows), enter "mysql -u yourusernamehere -p".
  3. Delete a MySQL Database Step 3.jpg
    3
    Enter your password when you are prompted
  4. Delete a MySQL Database Step 4.jpg
    4
    Once your into the MySQL terminal type "DROP DATABASE databasenamegoeshere;".
  5. Delete a MySQL Database Step 5.jpg
    5
    You can use "SHOW databases;" and look at your users visible list to confirm that the database has been deleted.
    Ad
Add your own method
Save

EditTips

  • Optionally you can do "DROP DATABASE IF EXISTS databasename;", this will prevent an error from being thrown if the database doesn't exist.
  • If you're connecting to a database that isn't localhost you should use mysql -u yourusernamehere -h yourhosthere -p.
  • If you don't have access to connect to the high level client you can connect directly to a database with mysql -u name databasenamegoeshere -p.
  • If you have the MySQL Workbench, once you login you can double click a connection to go to the database view. Right click the top level (database name) and click drop schema to drop the database.
Ad

EditWarnings

  • If you use "SHOW databases;" it will only show databases that your user has privileges to see, there could still be others you don't have access to see.

EditThings You'll Need

  • MySQL installed on the machine your working on (even if connecting to remote databases)

EditRelated wikiHows

How to
Administer MySQL

How to
Use MySQL

How to
Retrieve Data from Mysql

How to
Create a Database in Mysql

Article Info

Categories: MySQL

Recent edits by: Maniac, Maluniu, Teresa

In other languages:

Español: Cómo eliminar una base de datos MySQL, Italiano: Come Cancellare un Database MySQL

Ad

Thanks to all authors for creating a page that has been read 51,628 times.

Was this article accurate?

YesNo

Become
an Author!

Write an Article