Page 1 of 1

How do I set SUPER privilege for a user? phpmyadmin error "1044 - Access denied for user"

Posted: Fri Oct 30, 2020 4:37 pm
by jmart
Hi!

I was uploading a sql file and got this back.

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How do I set the super privilege to upload the file?

Thanks!!!!

Re: How do I set SUPER privilege for a user?

Posted: Fri Oct 30, 2020 10:54 pm
by myVesta
I think your SQL dump file contains

Code: Select all

CREATE DATABASE ...
which is of course unacceptable.

Edit your SQL file, delete

Code: Select all

CREATE DATABASE ...
and also delete

Code: Select all

USE ...
statements.

Your SQL file maybe also contains dump od 'mysql' database (at the end or at the top of file), you should also delete it from your SQL dump file.

Re: How do I set SUPER privilege for a user?

Posted: Sat Oct 31, 2020 12:54 am
by jmart
Thanks dpeca, it's working now! :D