By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

My RDS MySQL mas_ter account doesn't have enough privileges to allow me to create triggers

0

The AWS RDS docs say that the mas_ter user has TRIGGER rights, but mine does not. I don't know how to add it since my mas_ter user lacks the rights to change its own rights. How do I change the rights so that I can add triggers?

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database Service
Language
English
Chris Williams
asked a year ago232 views
1 Answer
3
Accepted Answer

check the following parameter for MySQL log_bin_trust_function_creators

https://mariadb.com/docs/skysql/ref/mdb/system-variables/log_bin_trust_function_creators/

it is false by default set to true (1) to enable Triggers

To do this you can create a new Parameter groups then change the relevant value and assign this Parameter Group to the RDS instance

profile picture
EXPERT
Sedat Salman
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content