In this tutorial, we will explore how to create a database, create a user, and assign permissions in cPanel. These steps are vital in setting up your website or application.

Step 1: Log in to cPanel

First, you’ll need to log into your cPanel account. You can find the cPanel URL in our welcome letter.

Enter your cPanel username and password, then click “Log in”.

Screenshot 2023 08 10 at 10.21.04 PM
Create Database, User, and Assign Permissions in cPanel 4

Or you can log in to cPanel by using our Client Area one-click login feature.

Services -> My Services -> Select your hosting service -> In Actions you can find “Login to cPanel”

Screenshot 2023 08 10 at 10.24.24 PM
Create Database, User, and Assign Permissions in cPanel 5

Step 2: Locate the MySQL Databases or Database Wizard

On your cPanel home page, find the “Databases” section. In this section, you should see the “MySQL Databases” and “MySQL Database Wizard” options.

Screenshot 2023 08 11 at 12.36.49 AM
Create Database, User, and Assign Permissions in cPanel 6

If you are creating a database for the first time, we recommend using the “MySQL Database Wizard” because this tool will guide you through all the steps, including creating a database, creating a user, and assigning permissions.

Step 3: Use the MySQL Database Wizard to Create a Database and User

Click on the “MySQL Database Wizard”, then follow the wizard’s instructions.

  1. Enter the name of the database in the “New Database” field, then click “Next Step”.
  2. On the “Add User” page, enter a username and password, then click “Create User”.
  3. On the “Manage User Privileges” page, select the privileges you wish to grant to the user, then click “Next Step”.

Step 4: Confirm the Database and User Have Been Created Successfully

On the final page, you should see a message saying that the database and user have been created successfully. Make a note of these details as you may need them when setting up your website or application.

Conclusion

Congratulations! You now know how to create a database, create a user, and assign permissions in cPanel. If you encounter any difficulties along the way, don’t hesitate to contact our customer service.