How to Delete MySQL Database in cPanel WordPress Hosting?
If you are a WordPress user most of the popular hosting companies like Bluehost, SiteGround, HostGator, etc. are using cPanel hosting for managing the account. cPanel has lot of options which is difficult for normal beginner level users to get familiar in shorter time frame. One such function is to delete the MySQL database from your WordPress installation. In this article we will explain step-by-step process of deleting MySQL database in cPanel WordPress hosting.
Why You Need to Delete a Database?
When you manage self-hosted WordPress sites you may need to play around with databases for multiple reasons. Below are some of the scenarios you may need to delete the database:
- When you install WordPress with one-click applications there is also an option to create an automatic database for your WordPress installation. If you have created database during this step but actually you have the backup database for importing then you may need to delete it.
- You created a testing or demo site and wanted cleanup the content.
- You are migrating to new host and wanted to delete all the existing content on the old host.
- You wrongly copied the database and wanted to get rid of the duplicate database.
Managing MySQL Database
phpMyAdmin is the tool used to manage databases in cPanel hosting accounts. Here you can edit the content of the database tables and delete the table part of any database on your hosting account.
But this tool does not offer an option to delete the complete database.
Deleting MySQL Database
Login to your cPanel account and navigate to the section related to databases. You will see the “MySQL Databases” icon as shown in the below picture (example from Bluehost).
Click on the “MySQL Databases” will take you to the screen where you can view all databases and user details available on your hosting account. Under “Current Databases” section find the one you want to delete.
Click on the “Delete” button and confirm the database deletion.
You will see the successful confirmation message like below.
That’s it!!! You have deleted the database occupying storage space on your server. Now go to phpMyAdmin and you will not find the database anymore.