Error:-
ERROR 1227 (42000) at line 18: Access denied; you need (at least
one of) the SUPER privilege(s) for this operation
Scenario:- I have taken a backup of the Mysql table using mysqldump and tried to restore the same in the Amazon AWS RDS
Cause:- The error occurs when database has the binary log enabled, and mysqldump file contains an object(trigger, view, function or event)
Now if any of the create statements dont include "NO SQL", "READS SQL DATA" or "DETERMINISTIC" keywords, than mysql cant write that object and import fails
Solution:-
Change the parameter group value
log_bin_trust_function_creators = 1
global_log_bin_trust_function_creators = 1 (More relaxed permission for
allowing import of all objects)
0 comments:
Post a Comment