Answers.Body: <p>If the Setup Screen tells you that the database settings are correct, it means you can login into the database with the username and password that you entered. However, it does not guarantee that the MySQL database user has enough privileges to perform all necessary database actions.
  CiviCRM needs <em>trigger support</em> and in the System Administrator Guide at <a href="https://docs.civicrm.org/sysadmin/en/latest/requirements/#mysql-permissions" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/requirements/#mysql-permissions</a> is described what this entails.</p>
  
  <p>If you are not able to grant the correct privileges in the control panel of your internet service provider, you have to contact their service desk.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-18T16:17:17.163Z
Answers.LastActivityDate: 2018-01-18T16:17:17.163Z
Answers.UserDisplayName: Kainuk - CiviCooP
Answers.Body: <p>This occurred to me too, my website was hosted with godaddy, i contacted them and they refused to allow 'Triggers' privileges on database while website is hosted with GoDaddy shared hosting plan. So i had to shift to <a href="http://www.ipage.com/" rel="nofollow noreferrer">iPage</a> which allows the required privilege.</p>
  
  <p>Hope this helps.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-18T19:44:27.443Z
Answers.LastActivityDate: 2018-01-18T19:44:27.443Z
Answers.UserDisplayName: Hassan Farooq
Answers.Body: <p>You might not be able to create triggers and stored procedures in shared hosting and might need to move to a cloud. I remember having these issues on godaddy too and moved to Ubuntu cloud. Call them and check. As I recall as a DBA you cannot create these without the super user privilege which isn’t possible in shared environments </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-19T00:34:48.540Z
Answers.LastActivityDate: 2018-04-19T00:34:48.540Z
Answers.UserDisplayName: Webmaster TheCMG
Answers.Body: <p>Usually cheap hosting costs you more in the longer run. There are some civi-specific hosting providers (CiviHosting springs to mind) &amp; using one of them will make you less sad</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-19T09:14:05.983Z
Answers.LastActivityDate: 2018-04-19T09:14:05.983Z
Answers.UserDisplayName: user4278
Body: <p>We are trying to setup CiviCRM in Wordpress.</p>
  
  <p>Our Database is on GoDaddy, but we are running into a problem:</p>
  
  <p>"Could not create a database trigger."</p>
  
  <p>The Database Settings appear to be correct.</p>
  
  <p>Any thoughts on how to fix this error?</p>
  
  <p>Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-01-20T07:34:22.383Z
Comments.Text: Please edit your question with what versions of Wordpress and CiviCRM you're using. No need to mention what host you are on. When you created the database to be used for CiviCRM, you need to make sure your database user has the permission for database triggers.
Comments.UserDisplayName: Christia
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-19T00:44:50.873Z
Comments.Text: It does help to mention the host, b/c the host (in this case GoDaddy) will not let you have the perms you need to create triggers. I found that problem w/a couple of other hosts. GD is one that won't let you create triggers, if you're using shared hosting there.
Comments.UserDisplayName: Lesley Evensen
Tags: <wordpress><error><database>
Title: Can I create triggers in the database?
ThreadText: # Can I create triggers in the database?
  
  (Asked by: username_0 on 2018-01-18)
  
  We are trying to setup CiviCRM in Wordpress.
  
  Our Database is on GoDaddy, but we are running into a problem:
  
  "Could not create a database trigger."
  
  The Database Settings appear to be correct.
  
  Any thoughts on how to fix this error?
  
  Thanks!
  
  **Tags:** wordpress, error, database
  
  > **Comments:**
  > **username_1**: Please edit your question with what versions of Wordpress and CiviCRM you're using. No need to mention what host you are on. When you created the database to be used for CiviCRM, you need to make sure your database user has the permission for database triggers.  
  > **username_2**: It does help to mention the host, b/c the host (in this case GoDaddy) will not let you have the perms you need to create triggers. I found that problem w/a couple of other hosts. GD is one that won't let you create triggers, if you're using shared hosting there.  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_3 on 2018-01-18. Score: 1
  
  If the Setup Screen tells you that the database settings are correct, it means you can login into the database with the username and password that you entered. However, it does not guarantee that the MySQL database user has enough privileges to perform all necessary database actions.
  CiviCRM needs *trigger support* and in the System Administrator Guide at <https://docs.civicrm.org/sysadmin/en/latest/requirements/#mysql-permissions> is described what this entails.
  
  If you are not able to grant the correct privileges in the control panel of your internet service provider, you have to contact their service desk.
  
  
  ---
  
  ### Answer by username_4 on 2018-01-18. Score: 1
  
  This occurred to me too, my website was hosted with godaddy, i contacted them and they refused to allow 'Triggers' privileges on database while website is hosted with GoDaddy shared hosting plan. So i had to shift to [iPage](http://www.ipage.com/) which allows the required privilege.
  
  Hope this helps.
  
  
  ---
  
  ### Answer by username_5 on 2018-04-19. Score: 0
  
  You might not be able to create triggers and stored procedures in shared hosting and might need to move to a cloud. I remember having these issues on godaddy too and moved to Ubuntu cloud. Call them and check. As I recall as a DBA you cannot create these without the super user privilege which isn’t possible in shared environments
  
  
  ---
  
  ### Answer by username_6 on 2018-04-19. Score: 0
  
  Usually cheap hosting costs you more in the longer run. There are some civi-specific hosting providers (CiviHosting springs to mind) & using one of them will make you less sad
  
  
  ---
  
  