11 November 2023
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.
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.
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.
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.
Create, collaborate, and turn your ideas into incredible products with the definitive platform for digital design.