How to Delete a Database or Database User

Deleting a database removes all of its tables and data permanently, and deleting a database user removes their access to any database they were linked to. Neither action can be undone from the control panel, so back up anything you might need before proceeding.

Export a backup of the database first if there's any chance you'll need the data again. Both cPanel and DirectAdmin include a phpMyAdmin export tool for this, or you can ask ZIPROF support to confirm your account's backup schedule already covers it.

In cPanel

Deleting a Database

1. Log in to cPanel and open MySQL Databases.
2. Under Current Databases, find the database and click Delete.
3. Type the database name to confirm, then click Delete Database.

Deleting a Database User

1. Under Current Users, find the username and click Delete.
2. Confirm the deletion.

In DirectAdmin

Deleting a Database

1. Log in to DirectAdmin and open MySQL Management.
2. Tick the checkbox next to the database you want to remove.
3. Click Delete, then confirm.

Deleting a Database User

1. Open the database the user is linked to.
2. Find the user in the access list and select the option to remove or delete them.
3. Confirm the removal.

Before You Delete

If a website or application is still actively using the database, deleting it will break that site immediately, usually with a database connection error. Confirm nothing is still pointed at the database or user before removing either one.