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?

asked 10 months ago194 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
answered 10 months 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