Restoring a User's Database Access

For WHM version 11.32

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:

This variable:	Stands for:
`$cpuser`	The cPanel username which has lost access to databases.
`{mysql, pg}`	The type of database: `mysql` for MySQL or `pg` for PostgreSQL.
`$dbuser`	The database user whose privileges you wish to restore. If you use `--dbuser`, the `$dbuser` variable will consist of the database user's name. If you use `--all`, the script will restore grants for all of the database users that belong to the cPanel account.

Updating 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:

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

The server administrator or reseller can:

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

Topic revision: r7 - 09 Sep 2011 - 16:18:20 - Main.RosieArcelay

AllDocumentation/WHMDocs.RestoringDatabaseAccess moved from Sandbox.RestoringDatabaseAccess on 27 Apr 2011 - 19:14 by Main.JustinSchaefer - put it back