Answers.Body: <p>In the MySQL CLI, run:</p>
  <p><code>SET GLOBAL log_bin_trust_function_creators=1;</code></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-02T14:04:45.993Z
Answers.Text: Thanks for contributing.  This answer was automatically flagged as having a low quality score.  To improve the quality, please explain what this does and why it solves the problem.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-19T03:59:58.767Z
Answers.LastActivityDate: 2021-01-19T03:59:58.767Z
Answers.UserDisplayName: todon2
Body: <p>MySQL 8.0.22-0ubuntu0.20.04.3 (Ubuntu)
  WordPress 5.6
  CiviCRM 5.32.2</p>
  <p>Attempting a fresh install of WP and CiviCRM on a clean AWS site as upgrading CiviCRM  was continually failing</p>
  <p>I get this error:</p>
  <p>System Requirements
  We are not able to install the software. Please review the errors and warnings below.</p>
  <p>Severity    Section Name    Details
  Error   Database    CiviCRM MySQL Trigger   Database does not support creation of triggers
  Refresh
  After updating your system, refresh to test the requirements again.
  Environment
  The system settings were auto-detected. CiviCRM will be installed with:</p>
  <p>CMS Database    mysql://wpdbuser:HIDDEN@localhost/wordpress</p>
  <p>CiviCRM Database<br />
  mysql://wpdbuser:HIDDEN@localhost/wordpress</p>
  <p>CiviCRM Settings File   /var/www/wordpress/wp-content/uploads/civicrm/civicrm.settings.php</p>
  <p>CiviCRM Source Code /var/www/wordpress/wp-content/plugins/civicrm/civicrm</p>
  <p>My Wordpress database user has full privileges including TRIGGER.</p>
  <pre><code>mysql&gt; SHOW GRANTS FOR 'wpdbuser'@'localhost';
  +-----------------------------------------------------------------+
  | Grants for wpdbuser@localhost                                   |
  +-----------------------------------------------------------------+
  | GRANT USAGE ON *.* TO `wpdbuser`@`localhost`                    |
  | GRANT ALL PRIVILEGES ON `wordpress`.* TO `wpdbuser`@`localhost` |
  +-----------------------------------------------------------------+
  2 rows in set (0.01 sec)
  </code></pre>
  <p>I specifically added TRIGGER</p>
  <pre><code>mysql&gt; GRANT  TRIGGER ON wordpress.* TO 'wpdbuser'@'localhost';
  Query OK, 0 rows affected (0.01 sec)
  </code></pre>
  <p>How can I resolve this ?      Is this a CiviCRM problem or a MySQL issue?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-23T23:41:11.553Z
Comments.Text: did you `FLUSH PRIVILEGES;` after making the changes?
Comments.UserDisplayName: Kevin Cristiano
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-24T12:34:13.090Z
Comments.Text: Hi Southside, a simular question is asked at https://civicrm.stackexchange.com/questions/11199/could-not-create-a-database-trigger-on-aws-rds/15624#15624 .
Comments.UserDisplayName: Kainuk - CiviCooP
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-24T14:20:11.423Z
Comments.Text: Does this answer your question? [Could not create a database trigger on AWS RDS](https://civicrm.stackexchange.com/questions/11199/could-not-create-a-database-trigger-on-aws-rds)
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <wordpress><installation>
Title: Installs fails with Error Database does not support creation of triggers - User has TRIGGER privilege
ThreadText: # Installs fails with Error Database does not support creation of triggers - User has TRIGGER privilege
  
  (Asked by: username_0 on 2020-12-23)
  
  MySQL 8.0.22-0ubuntu0.20.04.3 (Ubuntu)
  WordPress 5.6
  CiviCRM 5.32.2
  
  Attempting a fresh install of WP and CiviCRM on a clean AWS site as upgrading CiviCRM was continually failing
  
  I get this error:
  
  System Requirements
  We are not able to install the software. Please review the errors and warnings below.
  
  Severity Section Name Details
  Error Database CiviCRM MySQL Trigger Database does not support creation of triggers
  Refresh
  After updating your system, refresh to test the requirements again.
  Environment
  The system settings were auto-detected. CiviCRM will be installed with:
  
  CMS Database mysql://wpdbuser:HIDDEN@localhost/wordpress
  
  CiviCRM Database  
  mysql://wpdbuser:HIDDEN@localhost/wordpress
  
  CiviCRM Settings File /var/www/wordpress/wp-content/uploads/civicrm/civicrm.settings.php
  
  CiviCRM Source Code /var/www/wordpress/wp-content/plugins/civicrm/civicrm
  
  My Wordpress database user has full privileges including TRIGGER.
  
  ```
  mysql> SHOW GRANTS FOR 'wpdbuser'@'localhost';
  +-----------------------------------------------------------------+
  | Grants for wpdbuser@localhost                                   |
  +-----------------------------------------------------------------+
  | GRANT USAGE ON *.* TO `wpdbuser`@`localhost`                    |
  | GRANT ALL PRIVILEGES ON `wordpress`.* TO `wpdbuser`@`localhost` |
  +-----------------------------------------------------------------+
  2 rows in set (0.01 sec)
  
  ```
  
  I specifically added TRIGGER
  
  ```
  mysql> GRANT  TRIGGER ON wordpress.* TO 'wpdbuser'@'localhost';
  Query OK, 0 rows affected (0.01 sec)
  
  ```
  
  How can I resolve this ? Is this a CiviCRM problem or a MySQL issue?
  
  **Tags:** wordpress, installation
  
  > **Comments:**
  > **username_1**: did you `FLUSH PRIVILEGES;` after making the changes?  
  > **username_2**: Hi username_0, a simular question is asked at https://civicrm.stackexchange.com/questions/11199/could-not-create-a-database-trigger-on-aws-rds/15624#15624 .  
  > **username_3**: Does this answer your question? [Could not create a database trigger on AWS RDS](https://civicrm.stackexchange.com/questions/11199/could-not-create-a-database-trigger-on-aws-rds)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2021-01-19. Score: 4
  
  In the MySQL CLI, run:
  
  `SET GLOBAL log_bin_trust_function_creators=1;`
  
  > **Comments:**
  > **username_5**: Thanks for contributing.  This answer was automatically flagged as having a low quality score.  To improve the quality, please explain what this does and why it solves the problem.  
  
  ---
  
  