Arsal • Location • Starter

How to View and Manage Databases in cPanel

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:

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:

  1. Locate it in the list.
  2. Click the Delete (trash icon) option next to it.
  3. 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.