How to Set Privileges to a MySQL user Account in cPanel

March 22, 2023 / MySQL

This article explains how to set privileges to a MySQL user account in cPanel. MySQL in cPanel allows website owners to create and manage databases for their websites. Using the MySQL Databases feature in cPanel, website owners can create new databases, manage existing databases, and add or remove database users. cPanel also includes tools for importing and exporting database data, and for backing up and restoring databases.

To set privileges to a MySQL user account in cPanel, follow these steps:

  1. Log in to cPanel.
  2. Navigate to the “Databases” section and click on “MySQL® Databases Wizard”.
  3. Follow the steps to set Privileges to a MySQL user account in cPanel:
    1. Step1: Create A Database-

      1. Enter the name of the “New Database”, and click on the “Next step” button.create a database
    2. Step 2: Create Database Users-
      1. You will get a success message that the “MariaDB/MySQL database is been created”.
      2. Enter the “Username” and “Password” and click on the “Create User” button. (Note Username must be maximum of 40 characters and password generator can be used for generating the password. However, the password should be very strong).
      3. Click on the “Create User” button.
        Create User
    3.  Step 3: Add User to the Database-
      1. You will get a success message that the MySQL user is been created.
      2. Select the privileges. You can select specific privileges, or you can select all at once by ticking the “ALL PRIVILEGES” option.all privileges
      3. Click on the “Next step” button.
        next step
    4. Step 4: Complete the Task-
      1. You will get a success message that the new user is added to the database.
        complete the task
  4. Once you have set the privileges for the MySQL user account, the user will be able to perform the actions that you have allowed them to do on the selected database.

Ensure to check our latest web hosting plans and visit our Kb section for more such informative articles. Never hesitate to get in touch with our eukhost’s support team.

Spread the love