What is the procedure of restoring MySQL user grants.

April 23, 2021 / SQL

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.

Leave a Reply

Your email address will not be published. Required fields are marked *