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.

High load prevent slow backups

In this tutorial, we’ll explain to you how a high load creates a slow backup…

Modification of .NET Framework Virtual Directories in Plesk Control Panel

In order to provide running ASP.NET applications which use different NET framework versions within single…

What is an SPF record?

The SPF (Sender Policy Framework) record is the equivalent of a TXT record that determines…