How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help![enter image description here]1

1 Answer 1


You will need to grant access for mysql user to create triggers. You can run below command in mysql using super privilege user(root)

GRANT TRIGGER ON <db_name>.* TO '<db_user>'@'localhost';



  • Thanks! One more thing, I use RD on AWS for database and third party application like mysql workbench. Where can I run this command? Thanks so much again. Oct 5, 2018 at 17:13
  • There must be some window where you can run queries. You can also raise a request at AWS to grant access for your mysql user. Oct 5, 2018 at 17:17
  • I already put the command on the window in mysql workbench. Nothing happen. Maybe I will raise a request to AWS to grant access. Hmm. But I am using only a free tier on AWS, is there any chance to grant me an access for that? Thanks! Oct 5, 2018 at 17:20
  • or maybe there's a command to restart or implement the changes right away? thanks! Oct 5, 2018 at 17:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.