How to Restore User Database Access

This guide explains how to restore user database access. If a database user loses access to databases, you can restore their database grants using the ‘restoregrants’ utility or by updating the user’s password.

Follow the steps:

1. How to use the ‘restoregrants’ script:
   1. Use one of the subsequent commands from the command line to use restoregrants script to restore the user’s database access:

      /usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db=$type --dbuser=$dbuser

      /usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db=$type --all

   2. An explanation of the variables used in the overhead example:
      1. $cpuser: Refers to the cPanel username of the person who lost their database access.
      2. $dbuser: The database user who can restore the database.
         1. If you use the –dbuser flag, $dbuser describes the database user.
         2. If you use the –all flag, the script restores permissions for all database users associated with the cPanel account.
      3. $type: Refers to the type of database.
         1. mysql: MySQL®.
         2. pg: PostgreSQL®.
2. Update Password:
   The ‘restoregrants’ script may not always succeed in restoring database access. If the script fails, the cPanel user or the WHM user managing the account (such as a system administrator or reseller) can restore grants by resetting the cPanel account’s password.
   1. If you are a cPanel user, you can restore grants by following these steps:
      1. Go to the Password & Security interface in cPanel via cPanel >> Home >> Preferences >> Password & Security.
         
      2. Select Allow MySQL password change.
      3. Enter your old password in the Old Password text box.
         
      4. Enter a new password in both the New Password and New Password (again) text boxes.
      5. Click “Change your password now!”.
         
   2. If you are a Server Administrator or Reseller, you can restore grants by following these steps:
      1. Access the List Accounts interface in WHM via WHM >> Home >> Account Information >> List Accounts.
         
      2. Click the “+ link” next to the relevant account.
         
      3. Select Sync MySQL password with account password.
      4. Enter a new password in the Change Password text box.
      5. Click Change.
         

This method allows you to restore user database access. If you need further assistance, don’t hesitate to contact our support team.

Need to manage user permissions? Check out our guide on How to Grant all Privileges to the User in cPanel