How to Delete a MySQL® Database


Overview

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:

  1. Log in to the WHM interface as the root user.

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

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

  4. At the top of the interface, click Operations. A new interface will appear.

  5. Under the Remove database heading, click Drop the database (DROP).

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

  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.