[AWS RDS] Access denied; you need (at least one of) the SUPER privilege(s) for this operation

오류 1227을 해결하려면 log_bin_trust_function_creators의 파라미터 그룹 값을 1로 변경합니다.

이 조건을 완화하고 모든 객체의 가져오기를 허용하려면 RDS 사용자 지정 파라미터 그룹을 통해 global log_bin_trust_function_creators 시스템 변수를 1로 설정합니다.

Modifying Parameters in a DB Parameter Group

You can modify parameter values in a customer-created DB parameter group; you can't change the parameter values in a default DB parameter group. Changes to parameters in a customer-created DB parameter group are applied to all DB instances that are associated with the DB parameter group.

Changes to some parameters are applied to the DB instance immediately without a reboot. Changes to other parameters are applied only after the DB instance is rebooted. The RDS console shows the status of the DB parameter group associated with a DB instance on the Configuration tab. For example, if the DB instance isn't using the latest changes to its associated DB parameter group, the RDS console shows the DB parameter group with a status of pending-reboot. To apply the latest parameter changes to that DB instance, manually reboot the DB instance.

 

Console

To modify a DB parameter group

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

2. In the navigation pane, choose Parameter groups.

3. In the list, choose the parameter group that you want to modify.

4. For Parameter group actions, choose Edit.

5. Change the values of the parameters that you want to modify. You can scroll through the parameters using the arrow keys at the top right of the dialog box.

   You can't change values in a default parameter group.

6. Choose Save changes.

위 그림과 같이 log_bin_trust_function_creators 를 1로 바꾼다.

 

그리고나서 AWS RDS 재부팅!