Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #151618 Reply
    Ed Welch
    Guest

    I am getting an error message when trying to restore my website.
    [message] => Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation in /home/dh_db9hxu/cornerstonechurchwc.org/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-import.php:352

    What assistance can you provide?
    Thanks
    Ed

    #151653 Reply
    Brad Markle
    Keymaster

    Hello Ed,

    Thank you for reaching out to us. I understand how important it is to get your website restored smoothly, and I’m here to help.

    The error message you’ve provided indicates that the database user account being used for the restore process is missing specific privileges, such as SUPER or SET_USER_ID. These privileges are sometimes required for certain database operations, especially when dealing with advanced backup and restore features.

    Here are some steps you can take to resolve this:

    1. Check Database User Privileges:
      • Log in to your hosting provider’s control panel (e.g., cPanel or phpMyAdmin).
      • Navigate to the database user settings and ensure the user assigned to the database has all necessary privileges.
    2. Contact Your Hosting Provider:
      If you don’t have the option to modify the database user privileges, contact your hosting provider. Share the error message with them, as they may need to temporarily grant the required SUPER or SET_USER_ID privileges to complete the restore.
    3. Alternative Restore Methods:
      If modifying the privileges isn’t possible, try restoring your site using an alternative method:

      • Manual Restore: Extract the database file from your backup and import it manually using phpMyAdmin or a similar tool.
      • Command Line Restore: If you have SSH access, use a command-line tool like mysql to import the database.

    We’re happy to help, please keep us updated!

    – Brad

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Access denied from Restore
Your information: