Welcome to the SaHost Support Centre
To add a user to a database and add privileges in cPanel, follow these steps:
- Log in to your cPanel account.
- In theย Databasesย section,ย clickย MySQL Databases.
- Underย Current Databases,ย find the database that you want to add the user to and click theย Manage User Privilegesย link.
- Underย Privileged Users,ย click theย Add Privileged Userย button.
- In theย Usernameย field,ย select the username of the user that you want to add.
- 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:
- Underย Privileges,ย select the privileges that you want to grant to the user.
- 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.