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.