How to Manage My Databases in cPanel

Introduction

cPanel provides a simple and powerful interface to manage your MySQL databases. Whether you're building a website, installing a CMS like WordPress, or connecting a custom app, managing your databases properly is essential. This article explains how to view, modify, and manage your databases using cPanel's built-in tools.

Where to Find Database Tools in cPanel

After logging into cPanel, scroll to the Databases section. Key tools include:

• MySQL® Databases – Create, delete, and assign users to databases

• MySQL® Database Wizard – Step-by-step setup for new databases

• phpMyAdmin – Web-based interface to manage database content

• Remote MySQL® – Allow external connections to your database

View Existing Databases

1. Log in to cPanel

2. Click on MySQL® Databases

3. Scroll to the Current Databases section
   Here, you can:

• See all existing databases

• View assigned users

• Check database size

• Delete a database if no longer needed

Add a New Database

1. Under MySQL® Databases, go to Create New Database

2. Enter a name for your database

3. Click Create Database

Your database will now appear in the list of current databases.

Create a New Database User

1. Scroll down to MySQL Users

2. Enter a username and password

3. Click Create User

Tip: Use a strong password and store it safely.

Assign a User to a Database

1. Under Add User to Database, select the user and the database

2. Click Add

3. Choose the privileges (usually “All Privileges” for apps like WordPress)

4. Click Make Changes

Rename or Delete a Database

• You cannot rename a database in cPanel directly. You’ll need to create a new one and import data manually using phpMyAdmin.

• To delete a database, simply click Delete next to it in the list.

Check and Repair Databases

1. In MySQL® Databases, scroll to Modify Databases

2. Select the database you want to check or repair

3. Choose Check Database or Repair Database

Useful for fixing corruption or errors in database tables.

Backup Your Databases

You can back up databases via:

• phpMyAdmin (Export tab)

• Backup Wizard in cPanel

• Full cPanel backup (includes all databases)

Regular backups are strongly recommended before making any changes.

Conclusion

Managing your databases in cPanel is straightforward, thanks to its user-friendly tools. From creating and modifying databases to checking for errors and backups, everything is accessible in just a few clicks. Whether you're a beginner or experienced developer, these tools help you keep your website data organized and secure.