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
or
/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:

  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.

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
 

Copyright © cPanel 2000–2011.