{"id":393,"date":"2021-07-23T12:29:02","date_gmt":"2021-07-23T12:29:02","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/how-to-restore-a-users-database-access\/"},"modified":"2021-07-23T12:29:02","modified_gmt":"2021-07-23T12:29:02","slug":"how-to-restore-a-users-database-access","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/how-to-restore-a-users-database-access\/","title":{"rendered":"How to Restore a User’s Database Access"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

If a database user loses access to databases, you can restore the user\u2019s grants to the database with the restoregrants<\/code> utility.<\/p>\n

The restoregrants script<\/h2>\n

To use the restoregrants<\/code> script to restore the user\u2019s database access, run one of the following commands from the command line:<\/p>\n

\n
\n\n\n
\n
1\n<\/span>2\n<\/span><\/code><\/pre>\n<\/td>\n
\n
\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>cpanel<\/span>\/<\/span>bin<\/span>\/<\/span>restoregrants<\/span> --<\/span>cpuser<\/span>=$<\/span>cpuser<\/span> --<\/span>db<\/span>=$<\/span>type<\/span> --<\/span>dbuser<\/span>=$<\/span>dbuser<\/span>\n\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>cpanel<\/span>\/<\/span>bin<\/span>\/<\/span>restoregrants<\/span> --<\/span>cpuser<\/span>=$<\/span>cpuser<\/span> --<\/span>db<\/span>=$<\/span>type<\/span>  --<\/span>all<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n
The examples above use the following variables:<\/p>\n
    \n
  • $cpuser<\/code> \u2014 The cPanel username who lost access to their databases.<\/li>\n
  • $dbuser<\/code> \u2014 The database user whose privileges to restore.\n
      \n
    • If you use the --dbuser<\/code> flag, $dbuser<\/code> represents the database user.<\/li>\n
    • If you use the --all<\/code> flag, the script restores grants for all of the database users that belong to the cPanel account.<\/li>\n<\/ul>\n<\/li>\n
    • $type<\/code> \u2014 The type of database:\n
        \n
      • mysql<\/code> \u2014 MySQL\u00ae.<\/li>\n
      • pg<\/code> \u2014 PostgreSQL\u00ae.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
        Update password<\/h2>\n
        In certain circumstances, the restoregrants<\/code> script may fail to restore access to the database.<\/p>\n
        If the script fails, either the cPanel user or the WHM user who owns the account (the reseller or system administrator) can reset the cPanel account\u2019s password to restore grants.<\/p>\n
        The cPanel user can restore grants with the following steps:<\/p>\n
          \n
        1. \n
          Navigate to cPanel\u2019s Password and Security<\/em>
          \ninterface (cPanel >> Home >> Preferences >> Password & Security<\/em>).<\/p>\n<\/li>\n
        2. \n
          Select Allow MySQL password change<\/em>.<\/p>\n<\/li>\n
        3. \n
          Enter the old password in the Old Password<\/em> text box.<\/p>\n<\/li>\n
        4. \n
          Enter a new password in the New Password<\/em> and New Password (again)<\/em> text boxes.<\/p>\n<\/li>\n
        5. \n
          Click Change your password now<\/em>.<\/p>\n<\/li>\n<\/ol>\n
          The server administrator or reseller can restore grants with the following steps:<\/p>\n
            \n
          1. \n
            Navigate to WHM\u2019s List Accounts<\/em>
            \ninterface (WHM >> Home >> Account Information >> List Accounts<\/em>).<\/p>\n<\/li>\n
          2. \n
            Click the +<\/em> link next to the appropriate account.<\/p>\n<\/li>\n
          3. \n
            Select Sync MySQL password with account password<\/em>.<\/p>\n<\/li>\n
          4. \n
            Enter a new password in the Change Password<\/em> text box.<\/p>\n<\/li>\n
          5. \n
            Click Change<\/em>.<\/p>\n<\/li>\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
            Overview If a database user loses access to databases, you can restore the user\u2019s grants to the database with the restoregrants utility. The restoregrants script To use the restoregrants script to restore the user\u2019s database access, run one of the following commands from the command line: 1 2 \/usr\/local\/cpanel\/bin\/restoregrants –cpuser=$cpuser –db=$type –dbuser=$dbuser \/usr\/local\/cpanel\/bin\/restoregrants –cpuser=$cpuser –db=$type …<\/p>\n","protected":false},"author":1,"featured_media":394,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/393"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=393"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/394"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}