Announcement

Collapse
No announcement yet.

How to Restore Database Grants

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Restore Database Grants

    For cPanel & WHM version 11.52

    Overview

    If a database user loses access to databases, you can restore the user's grants to the database with the restoregrants utility.
    Use the restoregrants utility to restore the user's database access

    Execute either 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


    How to update the cPanel user's password to restore database access

    In certain circumstances, the restoregrants script may fail to restore database access.

    If this occurs, either the cPanel user or the WHM user who owns the account can reset the cPanel account's password to restore grants.

    cPanel users can reset the account password in the Change Password interface (Home >> preferences >> Change Password).

    WHM users can reset the password in the List Accounts interface (Home >> Account Information >> List Accounts).


    Regards,
    Dexter
    http://webhosting.uk.com
Working...
X