- AuthorPosts
- Ed WelchGuest
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:352What assistance can you provide?
Thanks
EdBrad MarkleKeymasterHello 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
orSET_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:
- 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.
- 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 requiredSUPER
orSET_USER_ID
privileges to complete the restore. - 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
- Check Database User Privileges:
- AuthorPosts
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)