When I try to import data to an Amazon RDS for 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

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 do not have the “NO SQL”, “READS SQL DATA”, or “DETERMINISTIC” keywords, MySQL cannot create those objects, and the import fails with error 1227.

To relax this condition, set the global log_bin_trust_function_creators system variables to 1 through the RDS custom parameter group. For more information, see Modifying Parameters in a DB Parameter Group.

Note: Default parameter groups cannot be edited, so you must create a custom parameter group and then modify the parameter.

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

Updated: 2018-01-03