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.
