DbSchema Database Designer

DbSchema | MySQL - How to Drop a Database?

Publish on DbSchema Blog >>>

In MySQL, databases are used to store collections of tables. If you no longer need a database, you can delete it. In this article, we will learn how to delete a database in MySQL.

Prerequisites

Before we begin, you should have the following:

  • Administrative privileges to delete databases

Deleting a Database

To delete a database in MySQL, follow these
steps:

  1. Open the MySQL client.
  2. Log in to the MySQL server using the following command:
mysql -u username -p

Replace __username` with your MySQL username. You will be prompted to enter your password.

  1. Once you are logged in, use the following command to delete the database:
DROP DATABASE dbname;

Replace __dbname` with the name of the database you want to delete.

  1. Verify that the database has been deleted by using the following command:
SHOW DATABASES;

This will display a list of all the databases on the MySQL server, excluding the one you just deleted.

Warning: Be careful when using the __DROP DATABASE` command as it permanently deletes the database and all its tables and data.

Drop Database and Visually Manage MySql using DbSchema

DbSchema is a MySQL client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.

Drop Database >

Drop Database

Open an SQL Editor in DbSchema, type and execute the drop database command

Conclusion

Deleting a database in MySQL is a simple process. You just need to log in to the MySQL server and use the __DROP DATABASE` command to delete the database. Remember to use this command with caution as it permanently deletes the database and all its data.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.


DbSchema can be downloaded for free. No registration is required.