How to add a user to a MySQL database in cPanel

July 18, 2022 / MySQL

This guide will explain to you how to add a user to a MySQL database in cPanel. MySQL databases are necessary to run many web-based applications, such as bulletin boards, content management systems, and online shopping carts.

To add a user to a MySQL database in cPanel, follow these steps:

  1. Log in to cPanel.
    login to cpanel

     

  2. Select the “Databases” section.
    databases

     

  3. Click on the “MySQL®Databases” option.
    MySQL databases
  4. “MySQL Databases” page will open up.
    databases
  5. Scroll down and find the “Add User to Database” option.
  6. Select the “User”.
    select user
  7. Select the “Database”.
    select database
  8. Click on the “Add” button.
    add
  9. As soon as you click on the add button you will enter a new page “Manage User Privileges”.
  10. Tick the box to enable “All Privileges”.
    all privileges
  11. Scroll down and click on the “Make Changes” button.
    make changes
  12. You will get a success message as shown below.
    success

This is how you can add a user to a MySQL database in cPanel. If you face any problem while doing so you can just contact our support staff for help.

Dominos Search