Answers.Body: <p>You will need to grant access for mysql user to create triggers. You can run below command in mysql using super privilege user(root)</p>
  
  <pre><code>GRANT TRIGGER ON &lt;db_name&gt;.* TO '&lt;db_user&gt;'@'localhost';
  </code></pre>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-05T17:13:46.157Z
Answers.Text: 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.
Answers.UserDisplayName: santiagoelie
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-05T17:17:41.000Z
Answers.Text: 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.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-05T17:20:19.780Z
Answers.Text: 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!
Answers.UserDisplayName: santiagoelie
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-05T17:24:30.477Z
Answers.Text: or maybe there's a command to restart or implement the changes right away? thanks!
Answers.UserDisplayName: santiagoelie
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-07T19:28:35.697Z
Answers.Text: AWS RDS [does offer trigger permissions to the master user](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html) a/c, see also [this SE answer for more help](https://stackoverflow.com/questions/8919907/can-i-create-trigger-in-an-rds-db).
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-07T19:31:29.327Z
Answers.Text: AWS RDS free tier might be cheap but you might have to invest a bit more time if it's not a platform in common usage by other civicrm users. CiviCRM can be picky about some platforms. If you do stick with RDS, please contribute your learning & notes about any special challenges to https://lab.civicrm.org/dev/cloud-native
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-05T17:11:09.440Z
Answers.LastActivityDate: 2018-10-05T17:11:09.440Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help<img src="https://i.sstatic.net/b7liZ.png" alt="![enter image description here">]<a href="https://i.sstatic.net/b7liZ.png" rel="nofollow noreferrer">1</a></p>
  
Tags: <database><aws>
Title: Could not create database trigger (AWS, RDS)
ThreadText: # Could not create database trigger (AWS, RDS)
  
  (Asked by: username_0 on 2018-10-05)
  
  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](https://i.sstatic.net/b7liZ.png)][1](https://i.sstatic.net/b7liZ.png)
  
  **Tags:** database, aws
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-10-05. Score: 0 | Accepted answer
  
  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 .* TO ''@'localhost';
  
  HTH
  Pradeep
  
  > **Comments:**
  > **username_0**: 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.  
  > **username_1**: 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.  
  > **username_0**: 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!  
  > **username_0**: or maybe there's a command to restart or implement the changes right away? thanks!  
  > **username_2**: AWS RDS [does offer trigger permissions to the master user](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html) a/c, see also [this SE answer for more help](https://stackoverflow.com/questions/8919907/can-i-create-trigger-in-an-rds-db).  
  > **username_2**: AWS RDS free tier might be cheap but you might have to invest a bit more time if it's not a platform in common usage by other civicrm users. CiviCRM can be picky about some platforms. If you do stick with RDS, please contribute your learning & notes about any special challenges to https://lab.civicrm.org/dev/cloud-native  
  
  ---
  
  