Skip to content

Instantly share code, notes, and snippets.

@atushi

atushi/How_to_set_about_log_bin_trust_function_creators_parameter_is_ENABLED_for_RDS.md

Last active May 7, 2018 02:13
Show Gist options
  • Save atushi/5855933 to your computer and use it in GitHub Desktop.
Save atushi/5855933 to your computer and use it in GitHub Desktop.
Download ZIP
AWS RDSに log_bin_trust_function_creators parameter is ENABLED を設定
Raw
How_to_set_about_log_bin_trust_function_creators_parameter_is_ENABLED_for_RDS.md

前提

  • default の Parameter Group は変更出来ない
    (こんなメッセージが出力される。 rds-modify-db-parameter-group: Malformed input-Cannot modify a default parameter group.)

e.g.

Parameter Group を Management Console 上で作成

  • Parameter Groups -> Create DB Parameter Group に遷移
  • default parameterが Name: default.mysql5.5、Family : mysql5.5 なので、Name: mysql5-5-for-trigger 、Family : mysql5.5 を作成
  • Management Consoleで対象のRDS instanceのParameter Groupsをmysql5-5-for-triggerに変更
  • Reboot

ターミナルからAPIで log_bin_trust_function_creators パラメータを ENABLED に設定

$ rds-modify-db-parameter-group mysql5-5-for-trigger --parameters="name=log_bin_trust_function_creators, value=on, method=immediate" --I "AWS Access ID" --S "AWS Secret Access Key" --region ap-southeast-1

Management Console 上で確認

  • Management Console -> RDS -> Parameter Groupsの設定で log_bin_trust_function_creators が 1 になっていること
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment