How to Delete a MySQL® Database

40 views Markdown

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:

Log in to the WHM interface as the root user.
Navigate to the SQL Services section (WHM >> Home >> SQL Services) and click phpMyAdmin. The phpMyAdmin interface will appear.
In the far-left column, select the database that you wish to delete.
At the top of the interface, click Operations. A new interface will appear.
Under the Remove database heading, click Drop the database (DROP).
Click OK to confirm that you wish to delete the database. A success message will appear.
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.

Was this helpful?

Thanks for your feedback!