SQL Error (1227): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I've been searching and searching, and cannot find a solution for this.

I have a fresh, clean install of HeidiSQL 10.3.0.5771, connecting to a MySQL db, but when I try to simply import (load) a .sql file, I get this error:

"SQL Error (1227): Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

When I try to add all the permissions for a user, I get this error:

"SQL Error (1045): Access denied for user 'xxxxx'@'%' (using password: YES)"

What in the world am I doing wrong?

After many HOURS of searching, reading, looking, I caught a friend who's a security guy, and he quickly figured it out.

Turns out that Amazon RDS does NOT give "SUPER USER" privileges to the master user (Search AWS Docs for "Master User Account Privileges") - AND - the "DEFINER" commands are what's causing the errors.

SO, REMOVING the "DEFINER" commands, then running the script, allows the dat to be imported (Search TecTut-com for "Solved – AWS RDS MySQL ERROR 1227 (42000) at line : Access denied")

I hope this helps others.

Thanks for your feedback, glad you fixed it!

By the way, you can exclude DEFINER clauses when creating the export: