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

Post Reply
jmart
Posts: 2
Joined: Thu Oct 22, 2020 3:50 pm

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!!!!
User avatar
myVesta
Site Admin
Posts: 924
Joined: Fri Jun 19, 2020 9:59 am
Has thanked: 8 times
Been thanked: 6 times

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.
jmart
Posts: 2
Joined: Thu Oct 22, 2020 3:50 pm

Thanks dpeca, it's working now! :D
Post Reply