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 Edit or Manage DNS Records in Plesk

How to Edit and Manage DNS Records in Plesk

In this article, we will explain how you can edit or manage DNS records in…

How to Set IMAP Path Prefix on iPhone

How to Set IMAP Path Prefix on iPhone

If you’re using an iPhone to manage your email and notice that some folders (like…

Exchange Dedicated Server: Historical Point of View

Exchange Servers started in 1993 and have grown significantly since then. Microsoft built it on…