Site Restoration

#36772 Restoring Database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Posted in ‘Site restoration’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version

n/a

CMS Type

Other

CMS Version

n/a

Backup Tool Version

n/a

Kickstart version

n/a

Latest post by on Sunday, 10 April 2022 20:17 CDT

Friday, 11 March 2022 04:29 CST

Molotov

Hello,

I have encountered issues with the restauration of one site with the new hosting set to use php 8.1.2

File extract worked fine but at the stage to restore mysql i got the error message:
Restoring Database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I changed the hosting to use php 7.4.27 , then it worked without problem. The original site was also set to 7.4.27. Can it be because of that?

Sorry if that is maybe a stupid question, i checked documentation and couldn't find infos on that issue.

Thanks for your feedback!

Edited by Molotov on 2022-03-11 04:29 CST

Friday, 11 March 2022 05:24 CST

tampe125

Hello,

can you please double check that the database really exists?

ANGIE will try to create it if it doesn't exist, but if you're on a shared hosting it's pretty rare to have enough privileges to create a new database, usually you have to do that from your Control Panel.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Sunday, 10 April 2022 20:17 CDT

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2022-04-10 20:17 CDT

Support