< Back
Print

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

  1. Log in to your cPanel account.
  2. In theย Databasesย section,ย clickย MySQL Databases.
  3. Underย Current Databases,ย find the database that you want to add the user to and click theย Manage User Privilegesย link.
  4. Underย Privileged Users,ย click theย Add Privileged Userย button.
  5. In theย Usernameย field,ย select the username of the user that you want to add.
  6. Click theย Addย button.

The user will now be added to the database. You can now grant the user the necessary permissions.

To grant the user permissions, follow these steps:

  1. Underย Privileges,ย select the privileges that you want to grant to the user.
  2. Click theย Make Changesย button.

The user will now have the selected permissions for the database.

Here are some additional tips for adding a user to a database and adding privileges in cPanel:

  • Only grant the user the permissions that they need.ย This will help to keep your database secure.
  • If you are adding the user to multiple databases,ย you can grant the user permissions for all of the databases at once by clicking theย All Databasesย checkbox.