Symptoms
You might see the following error message when importing a database through phpMyAdmin or otherwise as a cPanel (non-root) user:
Error
SQL query:
CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`localhost` ....
MySQL said:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s)
for this operation
Description
This error occurs when the database dump contains queries that cannot run as the current user, such as a query that creates a database under a different name or a query that defines a definer that is entirely a different user that might not even exist on the server.
Workaround
One method to solve this issue is to have your database administrator replace the related query with one that can be run as the current user, such as replacing the definer with the current username.
Another solution would be to edit the .sql dump file and remove the offending MySQL query line.
It is also possible to work around this issue by importing the database as the root user, but this is HIGHLY discouraged as the database dump may be compromised and could give unauthorized access to your entire system. Do not import a database as root unless you are aware of the implications of doing so.
If you're unsure of how to proceed with addressing the error, you may benefit from contacting a system administrator for further investigation. If you do not have such an administrator, you may search for one in our listings here:
Where do I find a system administrator?
However, please note that cPanel, LLC does not endorse or recommend any particular provider on that list, nor can we be held liable for any services performed by third-party providers, including those on the list.