How to Create and Manage Databases in cPanel

Databases are essential for storing and organizing your website’s data, such as content, user information, and transaction records. In this guide, we will walk you through the process of creating and managing databases in cPanel, a popular web hosting control panel provided by BDIX NOC and other hosting providers.

Step 1: Access cPanel

To begin managing your databases, you need to log into your cPanel account:

1. Go to the BDIX NOC cPanel login page (typically, this is accessed via https://yourdomain.com/cpanel or through your hosting provider’s dashboard).
2. Enter your username and password to log into cPanel.

Step 2: Create a Database

Once you're logged into cPanel, follow these steps to create a new database:

1. Locate the Databases Section:

   • Scroll down to the Databases section.
   • Click on the MySQL® Databases icon.

2. Create a New Database:

   • Under the Create New Database section, enter a name for your new database.
   • The name will automatically have your cPanel username as a prefix (for example, username_databasename).
   • After entering the name, click Create Database.

3. Create a Database User:

   • Scroll down to the MySQL Users section.
   • Enter a username and password for the new database user. The username and password must be secure to protect your data.
   • After entering the details, click Create User.

4. Assign User to Database:

   • In the Add User to Database section, select the database user you just created and choose the database you want to associate it with.
   • Click Add to assign the user to the database.

5. Set Privileges:

   • Once the user is added to the database, you will be prompted to assign privileges to the user. Select the necessary privileges based on your needs. You can check All Privileges to grant full access.
   • Click Make Changes to apply the privileges.

Your database is now created, and the user is assigned the necessary privileges to interact with it.

Step 3: Manage Your Database

Once your database is created, it’s important to manage it effectively. Here are some key features you can use in cPanel to manage your databases:

1. Access phpMyAdmin:

   • To manage and interact with your database, go to the Databases section and click on phpMyAdmin.
   • phpMyAdmin is a powerful tool that allows you to view, edit, and manipulate your database. You can add, delete, or modify database tables, and import or export data.

2. Backup Databases:

   • To backup your database, go to the Backup section in cPanel.
   • Under Download a MySQL Database Backup, select the database you want to back up.
   • Download the database as a .sql file, which you can store on your local system for safety.

3. Restore Databases:

   • To restore a database, go to the Backup section again.
   • Under Restore a MySQL Database Backup, upload the .sql file you backed up earlier and click Upload to restore the database.

4. Delete a Database:

   • To delete a database, return to the MySQL® Databases section in cPanel.
   • Under Current Databases, select the database you want to delete.
   • Click Delete, and confirm the deletion. This will remove the database and all its associated data permanently.

5. Manage Database Users:

   • You can add or remove users from a database at any time.
   • In the MySQL® Databases section, under Current Users, you can modify users’ privileges or delete users entirely if they no longer need access.

Step 4: Access and Use the Database in Your Website

After creating and managing your database, you’ll want to integrate it into your website. For example, in PHP or WordPress, you’ll need to update the connection details (database name, user, password, and host) in your website’s configuration file.

• WordPress: Update the wp-config.php file with the database details.
• PHP: Use the mysqli or PDO libraries to connect to the database using the credentials you’ve set up.

Step 5: Monitor Database Performance

• phpMyAdmin allows you to view and optimize database tables. Regularly check for any unnecessary data or large tables that might slow down your website.
• Consider running optimizing queries or using the Repair Database feature in phpMyAdmin to maintain performance.

Creating and managing databases in cPanel is a straightforward process that involves creating a database, assigning users, and ensuring the necessary privileges are in place. Managing databases efficiently can help optimize your website’s performance and data security.

At BDIX NOC, we ensure that you have all the tools you need to manage your databases effectively. If you encounter any issues or need assistance, you can always reach out to our 24/7 support team.