South Africa flag South African businesses: UK-quality hosting billed in Rand (ZAR) — your data stays in the UK, your invoice stays local. United Kingdom flag
EDZNET
  • Hosting
  • API
  • Domains
  • SSL
  • Bespoke Dev
  • Bespoke WP
  • QuickSite
  • Blog
  • Support
  • Login
  • 0
  • Get Hosting
  1. Home
  2. Knowledgebase
  3. Databases
  4. How to Add a User to a Database and Grant Privileges

  Categories

Backup/Restore
4
Cloudflare (cPanel)
9
CloudLinux (cPanel)
10
cPanel - Control Panel
25
Databases
11
DNS - Nameservers
6
Domain Management
10
Email
17
FTP
9
Mail Filters & SPAM
8
Mobile
11
Others
3
PayPal
7
Security
10
Security
2
SSL
5
WordPress
17

  Categories

  Tag Cloud

WAF Vulnerabilities Malware Scanner IP Reputation FIREWALL bitninja GreyList BalckList WhiteList cPanel WordPress WordPress Toolkit

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket

How to Add a User to a Database and Grant Privileges Print

  • 0

1. Log in to your cPanel account.

2. In the Databases section, click on MySQL Databases.
 

3. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list.

4. Click on Add.


5. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.


Was this answer helpful?

Related Articles

How to Create a Database in cPanel 1. Log in to your cPanel account.2. In the Databases section, click on MySQL Databases. 3. In the... How to Rename a Database in cPanel 1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3.... How to Delete a Database in cPanel 1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3.... How to Import a Database via phpMyAdmin in cPanel 1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. From the... How to Export Database Table via phpMyAdmin in cPanel 1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. From the...
« Back

  Tag Cloud

WAF Vulnerabilities Malware Scanner IP Reputation FIREWALL bitninja GreyList BalckList WhiteList cPanel WordPress WordPress Toolkit

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket
EDZNET

Premium managed UK hosting for businesses that can’t afford downtime. ISO/IEC 27001 data centres in London & Coventry. Serving UK and South African clients since 2019.

London Coventry

Services

  • Website Hosting
  • SSL Certificates
  • Domain Registration
  • Bespoke Development
  • Bespoke WordPress
  • QuickSite

Resources

  • Blog
  • Knowledgebase
  • API Guide
  • Network Status
  • Announcements
  • Affiliates

Company

  • Contact Us
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Acceptable Use
  • QuickSite Terms

UK Infrastructure

  • ISO/IEC 27001 facilities
  • Tier 3 data centres
  • 99.9% uptime SLA
  • UK GDPR & DPA 2018

Your IP: 216.73.216.252 US

All managed & shared hosting secured by BitNinja Server Security

Copyright © 2026 EDZNET. All Rights Reserved. England, Wales, Isle of Man & South Africa.

Made with and

EDZNET SUPPORT
Typically replies within minutes
👋 Hi there! Need help? Check our Quick Help guides first — or chat with us on WhatsApp. We're real developers, not bots.
Quick Help — Find instant answers Start Chat on WhatsApp

Loading...
Loading...

Choose Currency

R ZAR
£ GBP

Generate Password

Please enter a number between 8 and 64 for the password length