How to drop a database?

Dropping a database is a straightforward process, but it’s important to proceed with caution since this action permanently deletes the database and all its contents. Here’s how to drop a database using different methods in MySQL.

Using the MySQL Client

1. Log into the MySQL Client: Open your terminal and log in to the MySQL client with the following command:

   sudo mysql -u root
   

2. Drop the Database: Once you are in the MySQL client, use the DROP DATABASE command followed by the name of the database you want to drop. For example, to drop a database named hello_world, run:

   DROP DATABASE hello_world;
   

3. Verify the Deletion: To confirm that the database has been dropped, you can list all databases:

   SHOW DATABASES;
   

   You should no longer see hello_world in the list.

Using mysqladmin

Alternatively, you can drop a database using the mysqladmin command-line utility, which provides a safer way as it prompts for confirmation.

1. Exit the MySQL Client: If you are in the MySQL client, exit by typing:

   exit
   

2. Drop the Database: Use the following command in your terminal:

   mysqladmin -u root -p drop hello_world
   

   You will be prompted to confirm the action. Type y and press Enter to proceed.

Important Notes

• Irreversible Action: Dropping a database is irreversible. Ensure you have backups if needed.
• Active Connections: Make sure no one is connected to the database you are trying to drop, as active connections can prevent the operation from succeeding.

Example

Here’s a complete example of dropping a database named test_db:

# Log into MySQL
sudo mysql -u root

# Drop the database
DROP DATABASE test_db;

# Verify deletion
SHOW DATABASES;

If you have any further questions or need additional examples, feel free to ask!