Overview: How to Add a User to a Database and Grant Privileges
This guide explains How to Add a User to a Database and Grant Privileges step‑by‑step and why it matters for security, uptime, and performance. It’s written for small and medium businesses that rely on Blackhawk MSP for proactive, managed IT support in the Bay Area and beyond.
- ✅ Clear, actionable steps
- ✅ Best‑practice notes from our MSP engineers
- ✅ Links to related services and help
Tip: If you’re short on time, contact us — we’ll handle this for you and verify everything is working.
When managing a database in cPanel, it is important to add a user and set the right permissions for secure access. It ensures that only authorized users can make changes or retrieve data, keeping your websites database safe.
1. Log in to your cPanel account.
2. In the Databases section, click on Manage My Databases.
3. Scroll down to the end of the page and under Add User to Database, select a user and database from the drop-down list.
4. Click on Add.
5. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.
We hope this tutorial is helpful to you.
Video tutorial temporarily unavailable while we refresh links. If you need more help, please call us at 1-925-218-4000.
Need help? Blackhawk MSP can do this for you, verify success, and document the change. Call 1‑925‑218‑4000 or open a ticket.
