MySQL user grants

In this article, you will find the procedure of restoring MySQL grants.

The /usr/local/cpanel/bin/restoregrants script restores database users grants from the data in the /var/cpanel/databases/grants_* files.

One can restore the grants using the following command:

/usr/local/cpanel/bin/restoregrants [--cpuser=cpuser] [--db=mysql|pg] [--dbuser=dbuser|--all]

The above-discussed method is the basic and easiest way for restoring your MySQL user grants using the command line interface. For more details, you can visit bodHOST today.

Popular Posts You May Read

Explore more hosting insights, tips and industry updates.

How to Activate Leech Protection in cPanel

This post will show you how to activate Leech protection in cPanel. Let’s look at…

How to Install Clang on Ubuntu 20.04 and 22.04

This article illustrates how to install Clang on Ubuntu 20.04 and 22.04. Clang serves as…

Microsoft eCommerce Dedicated Servers

Applications installed on a Windows dedicated Server also include Commerce Server. It is basically a…