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?

已提問 2 年前檢視次數 308 次
1 個回答
3
已接受的答案

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
專家
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南