Answers.Body: <p>The problem is that the database user doesn't have some higher level privileges required for CiviCRM. Ask your ISP support or database administrator to run the following commands for you as the root MySQL user:</p>
  
  <p>-- Assuming a database called "civicrm" and a user called "civicrm_user" 
  -- and a MySQL version of 5.1.6+</p>
  
  <p>GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, 
      CREATE TEMPORARY TABLES, 
      LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.* 
      TO 'civicrm_user'@'localhost' IDENTIFIED BY 'realpasswordhere';</p>
  
  <p>For more details see:
  <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements" rel="noreferrer">http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-28T09:24:11.323Z
Answers.Text: If you use a server cluster that does replication of the mySQL database you may also need the 'super' privilege.
Answers.UserDisplayName: RocXa
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-29T00:12:02.623Z
Answers.Text: Agreed, though I suspect @f1mktsol is not at that level of sophistication.
Answers.UserDisplayName: Joe Murray
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-19T20:08:21.373Z
Answers.Text: In case it's useful, being configured to act as a master/using a binary logging caused this problem for me. Simply disabling the master/binary logging settings (which I didn't actually need) fixed it for me. Note - it was particularly misleading error as the database user had triggers setting enabled.
Answers.UserDisplayName: fred2
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-28T00:54:37.243Z
Answers.LastActivityDate: 2015-05-28T02:15:02.730Z
Answers.LastEditDate: 2015-05-28T02:15:02.730Z
Answers.UserDisplayName: Joe Murray
Answers.Body: <p>If you're using binary logging, you may need to add a line to your MySQL or MariaDB configuration (/etc/mysql/my.cnf) to proceed with the installation.</p>
  
  <pre><code>log_bin_trust_function_creators = 1
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-05T23:58:29.607Z
Answers.Text: This didn't work when added to my my.cnf file but, but did work when I ran this:
  
  set @@global.log_bin_trust_function_creators = 1;
  
  It allowed me to install CiviCRM on WordPress but I assume I'll still need to make that a permanent change in the conf file.
Answers.UserDisplayName: millionleaves
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-30T04:18:46.833Z
Answers.LastActivityDate: 2016-04-30T04:18:46.833Z
Answers.UserDisplayName: James Bradach
Answers.Body: <p>you should provide super privilege to the user
  <code>GRANT SUPER ON *.* TO 'user'@'%';</code></p>
  <p>for more information</p>
  <p><a href="https://www.educba.com/mysql-super-privilege/" rel="nofollow noreferrer">https://www.educba.com/mysql-super-privilege/</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-05T11:14:57.630Z
Answers.LastActivityDate: 2022-04-05T11:14:57.630Z
Answers.UserDisplayName: jayaprakash R
Body: <p>Trying to install to WordPress and I get; "Could not create a database trigger." I have no idea how to resolve. Thank you!</p>
  
Tags: <database><installation>
Title: Database Trigger error message
ThreadText: # Database Trigger error message
  
  (Asked by: username_0 on 2015-05-28)
  
  Trying to install to WordPress and I get; "Could not create a database trigger." I have no idea how to resolve. Thank you!
  
  **Tags:** database, installation
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2015-05-28. Score: 9
  
  The problem is that the database user doesn't have some higher level privileges required for CiviCRM. Ask your ISP support or database administrator to run the following commands for you as the root MySQL user:
  
  -- Assuming a database called "civicrm" and a user called "civicrm\_user"
  -- and a MySQL version of 5.1.6+
  
  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
  CREATE TEMPORARY TABLES,
  LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.\*
  TO 'civicrm\_user'@'localhost' IDENTIFIED BY 'realpasswordhere';
  
  For more details see:
  <http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements>
  
  > **Comments:**
  > **username_2**: If you use a server cluster that does replication of the mySQL database you may also need the 'super' privilege.  
  > **username_1**: Agreed, though I suspect @username_0 is not at that level of sophistication.  
  > **username_3**: In case it's useful, being configured to act as a master/using a binary logging caused this problem for me. Simply disabling the master/binary logging settings (which I didn't actually need) fixed it for me. Note - it was particularly misleading error as the database user had triggers setting enabled.  
  
  ---
  
  ### Answer by username_4 on 2016-04-30. Score: 8
  
  If you're using binary logging, you may need to add a line to your MySQL or MariaDB configuration (/etc/mysql/my.cnf) to proceed with the installation.
  log_bin_trust_function_creators = 1
  
  > **Comments:**
  > **username_5**: This didn't work when added to my my.cnf file but, but did work when I ran this:  set @@global.log_bin_trust_function_creators = 1;  It allowed me to install CiviCRM on WordPress but I assume I'll still need to make that a permanent change in the conf file.  
  
  ---
  
  ### Answer by username_6 on 2022-04-05. Score: 0
  
  you should provide super privilege to the user
  `GRANT SUPER ON *.* TO 'user'@'%';`
  
  for more information
  
  <https://www.educba.com/mysql-super-privilege/>
  
  
  ---
  
  