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

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

[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]

Thanks dpeca, it's working now!