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
How do I set SUPER privilege for a user? phpmyadmin error "1044 - Access denied for user"

Post 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!!!!

User avatar
myVesta
Site Admin
Posts: 574
Joined: Fri Jun 19, 2020 9:59 am
Re: How do I set SUPER privilege for a user?

Post 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.

jmart
Posts: 2
Joined: Thu Oct 22, 2020 3:50 pm
Re: How do I set SUPER privilege for a user?

Post by jmart »

Thanks dpeca, it's working now! :D


Post Reply