How to create a database and user and link them using cPanel?

August 29, 2020 8:33 am

We create the database for storing our data in tables and managing them in proper order. Here is the step by step description about creating the database and user and linking them using cPanel.

Video for creating Database and User and link then in cPanel:


Blog for creating Database and User and link then in cPanel:

  1. First, open your cPanel and search for databases table and then click on MySQL Databases.
    MySQL Database
  2. Enter your database name and then click on the create user button.
    creating database named babal in cpanel
  3. You will get database creation successful message.
    successful message after database creation
  4. Scroll down, after going back. Create a username of your choice and set password and click on the create user button.
    Creating user for database
  5. Scroll down and go to this section. Select the user you want to add and select the database for the above-selected users. And click on the add button to add.
    adding user to database
  6. After clicking the add button, this page appears. Tick on the all privileges and click on make changes.
    Giving Privileges to User of the Database
  7. You will get the successful message after making changes.
    success message for giving privileges