If a database user loses access to databases, you can restore the user's grants to the database with the
restoregrants utility to restore the user's database access
Execute either of the following commands from the command line:
The following table describes the variables in the example above:
|The cPanel username that has lost access to databases.|
|The type of database: |
|The database user whose privileges you wish to restore. If you use the |
How to update the cPanel user's password to restore database access
In certain circumstances, the
restoregrants script may fail to restore database access. If this occurs, either the cPanel user or the WHM user who owns the account can reset the cPanel account's password to restore grants.
- cPanel users can reset their account passwords in cPanel's Password & Security interface (cPanel >> Home >> Preferences >> Password & Security).
- WHM users can reset the password in WHM's List Accounts interface (WHM >> Home >> Account Information >> List Accounts).