When I attempt to import data to an Amazon RDS MySQL instance using mysqldump, I get an error similar to the following:

ERROR 1227 (42000) Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How do I fix this?

This error occurs when the destination database has the binary log enabled, and the mysqldump file contains an object (a trigger, view, function, or event).

If any of the create statements lack the “NO SQL”, “READS SQL DATA”, or “DETERMINISTIC” keywords, MySQL is prohibited from creating those objects, and the import fails with this error.

To relax this condition, enable “log_bin_trust_function_creators = 1” through the RDS custom parameter group. For more information, see Modifying Parameters in a DB Parameter Group.

Amazon RDS, MySQL, mysqldump, 1227, access denied

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2016-06-27