How do I set SUPER privilege for a user?

Post Reply
jmart
Posts: 2
Joined: Thu Oct 22, 2020 3:50 pm
How do I set SUPER privilege for a 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
dpeca
Site Admin
Posts: 236
Joined: Fri Jun 19, 2020 9:59 am
Location: Serbia, Niš
Re: How do I set SUPER privilege for a user?

Post by dpeca »

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 probably 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