RDS Error: Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

Amazon Relational Database Service does not allow functions, procedures, and triggers by default. This article explains the method to enable those in RDS.

Step1: Login to AWS console.

Step2: Open RDS console.

Step3: Create a DB parameter group if the instance is using deault parameter group. Otherwise this step can be ignored.

Step4: Modify the followin DB parameter in newly created group.

log_bin_trust_function_creators=1

Step5: Choose Save Changes.

Step6: Choose Databases from the navigation pane.

Step7: Choose the DB instance for which the new DB parameter group to be associated.

Step8: Choose Actions and choose Modify.

Step9: Select the required parameter group and apply the changes. It will take some time to complete the modification.

Step10: Reboot the DB instance instance without failover.

That's all…