It may happen that a user may not be able to access the databases. Using the restore grants utility, you can allow grants to a user to access databases if he loses the access grant.
Using any of the following commands given in the command line below, you can allow a user his/her grants to access a database. Execute the following commands to achieve your objective.
The descriptions of the variables are given below in a list. Read to follow through.
The users who lose access to the databases on a cPanel account can retrieve the access by the restore grants utility as the system works to restore the access following certain commands for this purpose. However, under specific circumstances, the system might fail to follow through and restore the grants successfully. In this case, the user of the cPanel or user of the WHM can opt for an alternative method by changing the password of the account.
The password of the cPanel account can be reset by the user to restore grants to people who need it.
This can be found at the path given by (cPanel >> Home >> Preferences >> Password &Security).
This can be found at the given path (WHM >> Home >> Account Information >> List Accounts).
This document puts down methods in which database grants can be restored using restore grants utility. Find alternative ways to restore grant rights if the system fails to cooperate in this document as well.