How to Delete a MySQL® Database

This document describes how to manually delete a MySQL® database from a cPanel & WHM server. This is useful if, for example, you converted your MySQL databases to a different database type, such as PostgreSQL® or SQLite.

Important:

We strongly suggest that you first try to delete databases through cPanel’s MySQL® Databases interface. If you manually delete a cPanel user’s database, the database map will become corrupt. This will cause errors and failures in backups because the system cannot properly remove outdated backups.

Delete MySQL Database

To delete a MySQL database, perform the following steps:

Step-1: Log in to the WHM interface as the "root" user.

Step-2: Navigate to the SQL Services section (WHM >> Home >> SQL Services) and click "phpMyAdmin". The phpMyAdmin interface will appear.

Step-3: In the far-left column, select the database that you wish to delete.

➤ Check Also: "System Backups" not being transported to my "Additional Backup" destination?

Step-4: At the top of the interface, click "Operations". A new interface will appear.

Step-5: Under the Remove database heading, click "Drop" the database (DROP).

Step-6: Click OK to confirm that you wish to delete the database. A success message will appear.

Step-7: If a cPanel user owned the database, navigate to cPanel’s MySQL® Databases interface and delete the database’s entry.

For more information about phpMyAdmin, visit the PhpMyAdmin documentation.