1

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

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';

HTH

Pradeep

  • 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. – santiagoelie Oct 5 '18 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. – Pradeep Nayak Oct 5 '18 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! – santiagoelie Oct 5 '18 at 17:20
  • or maybe there's a command to restart or implement the changes right away? thanks! – santiagoelie Oct 5 '18 at 17:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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