To drop (delete) a MySQL database, you can use the DROP DATABASE statement.

 Here's the basic syntax:

DROP DATABASE [IF EXISTS] database_name;
  • database_name: The name of the database you want to drop.
  • IF EXISTS: This is optional and ensures that an error will not occur if the specified database does not exist.
     

Here's an example:

DROP DATABASE IF EXISTS mydatabase;

If you are using a MySQL client, you can execute this SQL command directly in the SQL console or command line.

Here are the steps for dropping a database using the MySQL command line:

         1. Open a command prompt or terminal.

         2. Login to MySQL using the following command:

mysql -u your_username -p

Replace your_username with your MySQL username. You'll be prompted to enter your MySQL password.

          3. Once you are logged in, you can drop a database using the DROP DATABASE statement:

DROP DATABASE IF EXISTS mydatabase;


Replace mydatabase with the name of the database you want to drop.

          4.  After executing the command, the specified database will be deleted.

Note: Be cautious when using the DROP DATABASE statement, as it permanently deletes the specified database and its contents. Ensure that you have appropriate backups or are certain that you want to remove the database.