Answers.Body: <p>I found getting SUPER privileges by the host was necessary.
  After that the warning about Triggers disappeared.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-07T22:56:53.230Z
Answers.Text: I'm glad that worked, but that should not be necessary unless you're running a very old version of MySQL.  The need for SUPER privilege went away with MySQL 5.5.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-08T10:56:04.527Z
Answers.Text: same worked for me even though I think I have a reasonably current mysql version (`mysql  Ver 15.1 Distrib 10.2.21-MariaDB, for debian-linux-gnu (x86_64)`). I had changed and updated some packages on my vServer which broke the triggers until I granted SUPER privilege
Answers.UserDisplayName: sleidig
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-07-07T15:24:06.490Z
Answers.LastActivityDate: 2018-07-07T15:24:06.490Z
Answers.UserDisplayName: Ben Bachrach
Body: <p>Any suggestions how to get the civicrm installer to recognize that I have permission to create triggers. The installer says I don't, but my host says I do.
  I can create triggers with phpMyAdmin.
  I am using MySQL - it is a new site, but I don't know the version number. 
  I have asked. Will enter it when I know.</p>
  
  <p>Here I am substituting the word username for my real username.
  I logged into WordPress with user: username, and 
  logged into phpMyAdmin with user: username 
  I ran the query you suggested and got: 
  Your SQL query has been executed successfully. 
  SHOW GRANTS FOR 'username'@'localhost' GRANT USAGE ON . TO 'username'@'localhost' IDENTIFIED... 
  GRANT ALL PRIVILEGES ON username_site.* TO 'username'@'loc...<br>
  GRANT ALL PRIVILEGES ON username_civi.* TO 'username'@'loc... </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-07-06T23:44:06.237Z
Comments.Text: 1) Please confirm you're logged into phpMyAdmin as the same user as the CMS user and 2) please edit your question with the results of the following SQL: `SHOW GRANTS FOR 'username'@'localhost'`, substituting your own MySQL username (and the hostname if need be)
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-07-06T23:44:51.863Z
Comments.Text: Oh - and also please post the database software (MySQL/MariaDB/Percona/etc.) you're using along with the version?
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-07-08T20:03:27.580Z
Comments.Text: When you say *The installer says I don't*, it can help to share the **specific wording of the error message**. This makes it easier for helpers to know what you're seeing.
Comments.UserDisplayName: Chris Burgess
Tags: <installation>
Title: Installer says cannot create triggers but I can with phpMyAdmin
ThreadText: # Installer says cannot create triggers but I can with phpMyAdmin
  
  (Asked by: username_0 on 2018-07-06)
  
  Any suggestions how to get the civicrm installer to recognize that I have permission to create triggers. The installer says I don't, but my host says I do.
  I can create triggers with phpMyAdmin.
  I am using MySQL - it is a new site, but I don't know the version number.
  I have asked. Will enter it when I know.
  
  Here I am substituting the word username for my real username.
  I logged into WordPress with user: username, and
  logged into phpMyAdmin with user: username
  I ran the query you suggested and got:
  Your SQL query has been executed successfully.
  SHOW GRANTS FOR 'username'@'localhost' GRANT USAGE ON . TO 'username'@'localhost' IDENTIFIED...
  GRANT ALL PRIVILEGES ON username\_site.\* TO 'username'@'loc...  
  GRANT ALL PRIVILEGES ON username\_civi.\* TO 'username'@'loc...
  
  **Tags:** installation
  
  > **Comments:**
  > **username_1**: 1) Please confirm you're logged into phpMyAdmin as the same user as the CMS user and 2) please edit your question with the results of the following SQL: `SHOW GRANTS FOR 'username'@'localhost'`, substituting your own MySQL username (and the hostname if need be)  
  > **username_1**: Oh - and also please post the database software (MySQL/MariaDB/Percona/etc.) you're using along with the version?  
  > **username_2**: When you say *The installer says I don't*, it can help to share the **specific wording of the error message**. This makes it easier for helpers to know what you're seeing.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2018-07-07. Score: 1
  
  I found getting SUPER privileges by the host was necessary.
  After that the warning about Triggers disappeared.
  
  > **Comments:**
  > **username_1**: I'm glad that worked, but that should not be necessary unless you're running a very old version of MySQL.  The need for SUPER privilege went away with MySQL 5.5.  
  > **username_3**: same worked for me even though I think I have a reasonably current mysql version (`mysql  Ver 15.1 Distrib 10.2.21-MariaDB, for debian-linux-gnu (x86_64)`). I had changed and updated some packages on my vServer which broke the triggers until I granted SUPER privilege  
  
  ---
  
  