How to Delete a MySQL® Database

blog background image

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.

Related Blog Post

Create, collaborate, and turn your ideas into incredible products with the definitive platform for digital design.

What are NFT Domains?

02 February 2022

What are NFT Domains?

NFT domains are new web extensions that are deployed using ERC 721 and Polygon Network, except .zil which uses Zilliqa.

Read More
How to Delete a MySQL® Database

01 January 2022

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 exa

Read More
How to get Transfer Authorization Code from GoDaddy

11 November 2021

How to get Transfer Authorization Code from GoDaddy

To transfer your domain with us then must need EPP Code.

Read More
How to Enable Two-Factor Authentication (2FA) on Toshost

11 November 2021

How to Enable Two-Factor Authentication (2FA) on Toshost

If you want better account security, you should set up Two-Factor Authentication. With 2-Step Verification, you’ll pro

Read More
Why are my "system backups" not being transported to my "additional backup" destination?

11 November 2021

Why are my "system backups" not being transported to my "additional backup" destination?

If your cPanel system backups are not being automatically transported to your additional backup destination when backups

Read More
ভার্চুয়াল মেশিন কি - কিভাবে কাজ করে এবং এর ব্যাবহার।

10 October 2021

ভার্চুয়াল মেশিন কি - কিভাবে কাজ করে এবং এর ব্যাবহার।

ভার্চুয়াল মেশিন হলো এক ধরনের সফটওয়্যার কম্

Read More

Got a question!

Contact us at