If a database user loses access to databases, you can restore the user's grants to the database with the
The restoregrants script
To use the
restoregrants script to restore the user's database access, run one of the following commands from the command line:
/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db=$type --dbuser=$dbuser
/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db=$type --all
The following table lists the variables that the above example uses:
|The cPanel username who lost access to their databases.|
The type of database:
mysql for MySQL
pg for PostgreSQL®
The database user whose privileges you wish to restore.
- If you use the
$dbuser represents the database user.
- If you use the
--all flag, the script restores grants for all of the database users that belong to the cPanel account.
Update the cPanel user's password
In certain circumstances, the
restoregrants script may fail to restore access to the database.
If the script fails, either the cPanel user or the WHM user who owns the account (the reseller or system administrator) can reset the cPanel account's password to restore grants.
The cPanel user can restore grants with the following steps:
- Navigate to cPanel's Password & Security interface (Home >> Preferences >> Password & Security).
- Select Allow MySQL password change.
- Enter the old password in the Old Password text box.
- Enter a new password in the New Password and New Password (again) text boxes.
- Click Change your password now.
The server administrator or reseller can restore grants with the following steps:
- Navigate to WHM's List Accounts interface (Home >> Account Information >> List Accounts).
- Click the + link next to the appropriate account.
- Select Sync MySQL password with account password.
- Enter a new password in the Change Password text box.
- Click Change.