Showing posts with label Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s). Show all posts
Showing posts with label Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s). Show all posts

Saturday, August 8, 2020

Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s)

While importing mysql database if you get the above error, it means the Definer is not same as the user which you are using to import the database.

If Definer is set as root in you sql file, either import the database using root user or you need to change the Definer in sql file with the username which you are using to import database.

You can find a line like this in your sql file

DEFINER = 'root'@'%'
or
DEFINER = 'root'@'localhost'

or

DEFINER = 'root'@'your-mysql-hostname'

You need to change root with your mysql user.