Step 1: Open the Databases Section:
On the cPanel dashboard, scroll down or use the search bar to find the Databases section. Click on it to expand and reveal the available tools.
Step 2: Click "Manage My Databases":
From the expanded list, click on Manage My Databases. This opens a page showing all the databases currently associated with your hosting account.
Step 3: View Your Database List:
On this page, you'll typically see a table with columns such as:
- Database Name : the name of each database
- Size : how much storage each database is using
- Privileged Users : which users have access to that database
- Actions : options like delete or modify
Review this list to get a clear picture of how many databases you have and how much space each one takes.
Step 4: Create New Database:
Click “Create Database” to create the new database.
Step 4: Check Database Size and Usage:
Look at the Size column to identify any databases that may be unusually large. This helps you keep track of storage usage, especially if your hosting plan has limits.
Step 5: Modify a Database User's Privileges (If Needed):
Some versions of this tool let you click on a database to see its assigned users. From here, you can:
- Add an existing user to a database
- Adjust the user's privileges (e.g., change from limited access to ALL PRIVILEGES)
- Remove a user from the database
Step 6: Delete a Database (If No Longer Needed):
If you find a database that's no longer in use:
- Locate it in the list.
- Click the Delete (trash icon) option next to it.
- Confirm the deletion when prompted — note that this action is permanent and will erase all data inside that database, so make sure you have a backup if needed.
Step 7: Back Up Before Major Changes:
Before deleting or modifying anything significant, it's a good practice to export a backup of the database using phpMyAdmin (Export tab) first, just in case you need to restore it later.
Step 8: Refresh and Confirm Changes:
After making any changes (deleting a database, adjusting privileges), refresh the page to confirm the list now reflects the updated state.