This document describes the way to manually delete a MySQL® info from a cPanel & WHM server. this is often helpful if, as an example, you regenerate your MySQL infos to a distinct database sort, like PostgreSQL® or SQLite.
Important:
We powerfully recommend that you simply 1st attempt to delete databases through cPanel’s MySQL® Databases interface. If you manually delete a cPanel user’s info, the info map can become corrupt. this may cause errors and failures in backups as a result of the system cannot properly take away obsolete backups.
Delete MySQL info
To delete a MySQL info, perform the subsequent steps:
Step-1: Log in to the WHM interface because the "root" user.
Step-2: Navigate to the SQL Services section (WHM >> Home >> SQL Services) and click on "phpMyAdmin". The phpMyAdmin interface can seem.
Step-3: within the far-left column, choose the info that you simply want to delete.
Step-4: At the highest of the interface, click "Operations". a brand new interface can seem.
Step-5: beneath the take away information heading, click "Drop" the information (DROP).
Step-6: Click alright to ensure that you simply would like to delete the information. a hit message can seem.
Step-7: If a cPanel user in hand the information, navigate to cPanel’s MySQL® Databases interface and delete the database’s entry.
For a lot of data concerning phpMyAdmin, visit the PhpMyAdmin documentation.
Witten by sciencewhile.
