Step 1: Login to the cPanel account.
Step 2: Click MySQL Database under Database section.
Step 3: To assign a new user to the database. Go to Add User to Database.
Step 4: Select the user’s form the drop-down list box.
Step 5: Select corresponding database drop-down list.
Step 6: Click Add button after selecting the respective user and database.
Step 7: Then it redirects us to next page to assign the User’s privileges of the current user. By selecting all privileges checkbox.
Step 8: After assigning the privileges to the user click Make changes button.
Step 9: After click make changes. The pages redirect to next page and display the message for the action has been done.