Support

Site Restoration

#37003 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
8.12
CMS Type
Joomla!
CMS Version
4.12
Backup Tool Version
9.21
Kickstart version
7.12

smudge11

This topic was listed, but closed without an answer.

I am having the same issue. I have created the new database in my host control panel, and confirmed the user name has all privileges.

I have done site restores many times in the past without issue. Is this a php 8 issue?

I am attempting to move an upgraded Joomla 4 site to the client's host.

The site listed above is the client's Joomla 3 site that will be replaced with the new J4 site.  

Thank you for any info. 

nicholas
Akeeba Staff
Manager

I suppose you refer to https://www.akeeba.com/support/site-restoration/36772-restoring-database-access-denied-you-need-at-least-one-of-the-super-privilege-s-for-this-operation.html which was closed automatically because the client never replied to our question.

The error message comes from MySQL itself. I would like to know when it happens, though. So I need to ask you a few questions.

1. Which driver are you using: MySQLi or PDOMySQL? Please specify.

2. Please include a screenshot with the entire page of the restoration script. I need to know if it happens executing a SQL statement creating a procedure, function or trigger; or if it happens when we connect to the database server.

3. Are you using MySQL or MariaDB? What is the exact version? You may find that information in your hosting control panel. Otherwise please do ask your host.

The reason I am asking these questions is that the error message you get occurs in two separate circumstances. One is if we try to use the SET command to set a MySQL session variable but the user is not allowed to do that and the other one if you are executing a create statement for a procedure, function or trigger with a definer. The latter shouldn't happen since we remove the definers when dumping the database; it also wouldn't depend on the PHP version. I do leave a very small probability of a potential issue in an edge case we haven't seen  before, that's why I am not discounting this outright. The former, however, can happen and it might be PHP version specific since PHP database drivers may also execute their own SQL statements when connecting to a database.

Having the answers to my questions would let me understand what is going on. I will have to see if it can be reproduced and then see if it can be fixed. I have a suspicion this happens only with the PDOMySQL driver and switching to MySQLi might fix it. But let's not get ahead of ourselves.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

smudge11

Thanks Nicholas. I switched the hosting back to php 7.4, and was able to get the client site restored.

I have another personal site with the same issue that I have not resolved yet. I will try that in the next day or so and try to get you as much information on the process as possible.

Both sites are using MYSQLi. 

nicholas
Akeeba Staff
Manager

Try switching between the two database drivers. If the problem persists do provide the information I requested above and we'll see what we can do about it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!