How to Restore a User Database Access?

introduction

In some cases, the users of your server can all of a sudden lose access to their databases when the database grants, i.e., the permissions to use the database, get corrupted or lost. There are two broad methods to fix this issue, and they are: running the restoregrants utility script or by just changing the password of the cPanel account.

Method 1: Using the restoregrants Script

The restoregrants utility is a powerful command-line script. It is meant to reapply the right database permissions to a user. You must run this command from the server’s command line with root access.

1. Command Syntax and Variables

You can use two different forms of the command-based: restore grants for one database user or all of them.

• For a single specific database user:
  $/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db=$type –dbuser=$dbuser
• For ALL database users of an account:
  $/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db=$type –all

2. Understanding the Variables

The commands use a few variables, which you need to substitute with the real data.

• $cpuser: This is the cPanel user name of the account that has lost access to its database.
• $dbuser: This means the particular user of the database whose grants one needs to restore. This variable is only used when you use the dbuser flag in the command.
• $type: This will be the type of database being used. The common options are:
  mysql: For MySQL databases.
  pg: In the case of PostgreSQL databases.
• –all: When you use the –all flag instead of –dbuser, the script will help and set the permissions back to all single database users associated with the specified cPanel account.

Method 2: Updating the cPanel Account Password

In some unusual situations, the restoregrants script may not restore access to the database correctly. When this occurs, a password reset of the cPanel account may at times cause the system to automatically fix and restore the database grants.

1. Procedures for a cPanel User

If you are the cPanel account user, you can follow the following steps in order to reset your password and restore the grants.

• Access Password and Security: Go to the cPanel dashboard. Thereafter, go to Home/Preferences/Password & Security.
• Allow MySQL Change: It is important to make sure that one selects or chooses the option of ‘Allow MySQL password change’.
• Enter Passwords: Type in your old Password in the first text box. Next, input a New Password in the following two boxes for confirmation.
• Change Password: Click on the Change your password now button.

    2. Procedures for a WHM User

In case you are a Server Administrator or a Reseller and control the account, you can perform the password reset with the help of WHM.

• Access List Accounts: Log into WHM. Then go to Home >> Account Information >> List Accounts.
• Find the Account: Find the correct cPanel account on the list. Click the + link next to its entry to expand the options.
• Sync MySQL Password: Ensure that you choose the option: Sync MySQL password with account password.
• Enter New Password: Enter a new password in the designated Change Password text box.
• Finalize Change: Click on the Change button.

Thus, you have successfully restored the user’s database access with the above steps.

Cantech’s Features in Database Reliability

The integrity of the database is paramount at Cantech. We have secure hosting environments that have full support of the cPanel/WHM utility scripts. This includes the essential restoregrants script for quick fixes. We provide both administrative access for command-line solutions and easy-to-use WHM interfaces for system administrators and resellers. This ensures your users’ database access remains reliable.

Conclusion

Lost database grants can be restored effectively using two reliable methods. The restoregrants script provides precise control to command-line users. Alternatively, a simple cPanel password update can automatically repair permissions. The techniques make sure that database services are promptly restored to the user, so their applications continue to run without problems.

Frequently Asked Questions

What does the restoregrants script actually do?

The restoregrants script forces the system to re-read and reapply all the original database permissions or grants that were assigned to a specific database user.

When should I use the password update method instead of the script?

You should use the password update method if you find that the restoregrants script fails to fix the access problem. Resetting the password is a reliable backup solution.

What is the difference between the –dbuser and –all flags?

The –dbuser flag restores permissions for one specific database user. The –all flag restores permissions for every single database user associated with that cPanel account.

As a WHM user, why must I select ‘Sync MySQL password with account password’?

Selecting Sync MySQL password with account password forces the system to treat the cPanel password change as an action that should also update and re-sync the linked MySQL database grants.

Does the cPanel user need to enter their old password when changing it?

Yes, the cPanel user must enter their old password when changing it through the interface. This confirms their identity and security before they can set a new one.