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.

PHP Script to Test MySQL Database Connectivity

A test for MySQL database connectivity is done using the PHP script mentioned below. It…

What to Do When One or More Devices Failed Backup?

Here is the solution to solve when one or more devices fail in backup (error…

What is the procedure for resetting an FTP user’s password?

This article explains what FTP is and how to change an FTP user’s password. What…