Restoring a User's Database Access

For WHM version 11.38

If a database user loses access to databases, you may be able to restore the user's grants to the database using the restoregrants utility.

Using Restoregrants to Restore the User's Database Access

Execute one of the following commands from the command line:

/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db={mysql, pg} --dbuser=$dbuser

/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db={mysql, pg}  --all

In the example above:

How to Update the cPanel User's Password to Restore Database Access

In certain circumstances, the restoregrants script may fail to restore access to the database.

If this occurs, either the cPanel user or the WHM user who owns the account (that is, the reseller or system administrator) can restore grants by resetting the cPanel account's password.

The cPanel user can:

1. Navigate to cPanel > Change Password.
2. Select Allow MySQL password change.
3. Change the password and click Change your password now.

The server administrator or reseller can:

1. Navigate to WHM > List Accounts.
2. Click + next to the appropriate account.
3. Select Sync MySQL password with account password.
4. Enter a new password into the Change Password box and click Change.