How to Create a New MySQL Database in cPanel?

Creating a new MySQL database in cPanel is a straightforward process. Here’s a step-by-step guide to help you set up your database.

Step 1: Log in to cPanel

1. Open Your Web Browser:
• Navigate to your cPanel URL (e.g., https://yourdomain.com/cpanel).
2. Enter Your Credentials:
• Log in using your cPanel username and password.

Step 2: Locate the Databases Section

1. Find the Databases Section:
• In the cPanel dashboard, scroll down to the "Databases" section.

Step 3: Click on MySQL Databases

1. Select MySQL Databases:
• Click on the "MySQL Databases" icon. This will take you to the database management area.

Step 4: Create the New Database

1. Enter Database Name:
• In the "Create New Database" field, enter a name for your new database. It’s a good practice to use a descriptive name.
2. Click Create Database:
• After entering the name, click the "Create Database" button.
3. Confirmation:
• You’ll see a confirmation message indicating that the database has been created successfully.

Step 5: Create a Database User

1. Scroll to the MySQL Users Section:
• In the same MySQL Databases interface, find the "MySQL Users" section.
2. Add a New User:
• Enter a username and a strong password for the new database user.
3. Click Create User:
• Click the "Create User" button.

Step 6: Add User to Database

1. Add User to Database:
• In the "Add User to Database" section, select the user you just created from the dropdown.
2. Select the Database:
• Choose the database you created earlier from the dropdown menu.
3. Click Add:
• Click the "Add" button.
4. Set Privileges:
• On the next screen, you can set the user privileges. For most applications, select "All Privileges." Then click "Make Changes."

Conclusion

You’ve successfully created a new MySQL database and user in cPanel! You can now use this database for your applications, such as WordPress or other CMSs. Always remember to keep your database credentials secure and back up your data regularly.