How To Clear A MySQL Database

Some web hosting will limit the amount of MySQL database that can create in one account. If you need more MySQL databases, probably you may want to upgrade your web hosting account. In this post, we will show you that how can you clear a MySQL database using cPanel.

How To Clear A MySQL Database?

First of all, log in to cPanel.

Clear A MySQL Database

Go to PhpMyAdmin.

open phpmyadmin

You need to select the database. Make sure that you have chosen the right one.

choose db

On the next screen, you can see all the tables there. Simply select them all and from the drop-down menu, choose an option called drop.

select tables

Simply run it.

run db clean

Now, you can see that all the tables are gone. Your database is fresh now.

db cleaned

This is how you can clear a MySQL database using cPanel. We hope you found this post helpful and enjoyed the read. If you did, please consider sharing this post with your friends.

You may also want to check how can you install PDO extension, Mcrypt extension, Mbstring extension on your website using cPanel.

Leave a Reply