Host Knowledgebase
  • Home
    • Main Website
    • Blog
    • Knowledgebase
  • Categories
    • Cloud Computing
    • Cloud hosting
    • Cloud Technology
    • Cluster
    • CMS Hosting
    • Colocation Services
    • cPanel Hosting
    • cPanel/WHM
    • Data Center Services
    • database
    • Dedicated Servers FAQ's
    • Dedicated Web Hosting
    • Domain Name FAQs
    • Domain Names
    • Domain Registration
    • E-Commerce Hosting
    • Email Hosting FAQ's
    • Emails
    • Fantastico
    • General
    • Host
    • Imunify360
    • Linux and Windows
    • Linux VPS Hosting
    • MySQL
    • PHP hosting
    • Plesk Account
    • Pre-Sales Questions
    • Reseller Hosting
    • Security
    • Shared Web Hosting
    • SSL certificate
    • Tomcat
    • virtualization
    • VPS Hosting FAQ's
    • VPS Web Hosting
    • Web Hosting
    • Web Hosting FAQ's
    • Web Hosting Related
    • Web Hosting Resources
    • Web Hosting Support
    • Website Migration
    • Website security
    • Windows hosting
    • Windows Hyper-V Hosting
    • Windows MS SQL FAQ's
    • WordPress
    • WordPress hosting

How to provide all privileges to a user in MySQL

/Dedicated Web Hosting /How to provide all privileges to a user in MySQL
  • October 27, 2021
  • Seema Shaikh

This article explains how to provide all privileges to a user in MySQL. The MySQL privilege system authenticates a user to make specific changes in a database. Based on the privileges granted in cPanel, a user can carry functions like SELECT, INSERT, UPDATE, DELETE, etc. on the database.

Follow these steps to provide all privileges to a user in MySQL:

1. Visit your cPanel account as well as log in.

2. Select MySQL® Databases from the Databases section.

3. In the MySQL Users section, scroll to the bottom to the “Add User To Database” section. Select the User to whom you want to assign rights, as well as the Database to which you want to assign them. After that, click the Add button.

4. You’ll be sent to “Manage User Privileges”, where you can choose which privileges the user should have.

5. Tick the ALL PRIVILEGES box and click the Make Changes button to give the user all privileges.

6. A success message will appear, indicating that the system has saved the user’s selected privileges.

7. At the bottom of the list, select Go Back.

8. You’ll return to MySQL® Databases later. The user you just gave privileges to can be found in the “Current Databases” table’s Privileged Users column.

In this way, you can grant all the privileges to a user in MySQL using cPanel. For any query contact our support staff and don’t forget to check our web hosting plans today.

Tagged:cPanelcPanel accountMySQLWHM

Related Articles

  • Can a Dedicated IP be Purchased with Shared Hosting?

  • How to Generate Web Users in Plesk

  • Make your Server More Secure

  • How to Disable the DNS Zone in WHM

  • How to Use Nginx to Block IPs?

  • How to Delete a CNAME Record from cPanel

Latest Articles

  • Key Differences between SMTP, IMAP, and POP3
  • How to Find Out What CMS Does a Website Use?
  • A Complete Guide to Remote Direct Memory Access (RDMA)

Categories

  • Cloud Computing
  • Cloud hosting
  • Cloud Technology
  • Cluster
  • CMS Hosting
  • Colocation Services
  • cPanel Hosting
  • cPanel/WHM
  • Data Center Services
  • database
  • Dedicated Servers FAQ's
  • Dedicated Web Hosting
  • Domain Name FAQs
  • Domain Names
  • Domain Registration
  • E-Commerce Hosting
  • Email Hosting FAQ's
  • Emails
  • Fantastico
  • General
  • Host
  • Imunify360
  • Linux and Windows
  • Linux VPS Hosting
  • MySQL
  • PHP hosting
  • Plesk Account
  • Pre-Sales Questions
  • Reseller Hosting
  • Security
  • Shared Web Hosting
  • SSL certificate
  • Tomcat
  • virtualization
  • VPS Hosting FAQ's
  • VPS Web Hosting
  • Web Hosting
  • Web Hosting FAQ's
  • Web Hosting Related
  • Web Hosting Resources
  • Web Hosting Support
  • Website Migration
  • Website security
  • Windows hosting
  • Windows Hyper-V Hosting
  • Windows MS SQL FAQ's
  • WordPress
  • WordPress hosting

About Host

We're the best hosting solutions provider in india with a team of highly qualified and motivated engineers. We are experts at providing you services to register your domain, transfer of your domain and domain protection with the required privacy. We are expert in providing you with cPanel hosting along with Windows, Linux and Word press hosting. We support you with servers such as Linux, Windows VPS, Cloud and Dedicated servers. We provide innovative reseller experience in both Linux and Windows Operating System. You can completely rely on us when it comes to Security, we are SSL certified and we provide backup facility. You need not worry about email spam as we offer the best anti-spam software. We ensure high availability, increased scalability, good connectivity as well best Colocation services by Host.co.in Find out more.

Web Hosting

cPanel Hosting

Window Shared hosting

WordPress Hosting

Reseller Hosting

Windows Reseller Hosting

Linux Reseller Hosting

Copyright © 2016 - 2017, Host.co.in. All rights are reserved.