CiviCRM Community Forums (archive)

After going through the install instructions, the page on MySQL Permissions is a bit hard to follow.

http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements

I understand that I need to add an extra trigger because my version of MySQL is 5.5.32.

When I cut'n'paste the trigger into the "Triggers" section in phpMyAdmin (I assume this is the place for it to go!), I get the following error:

MySQL said: #1422 - Explicit or implicit commit is not allowed in stored function or trigger

What does this mean, and what should I do? Is it necessary to add these triggers somewhere? Where?

The page authors have written "More information on triggers is available in the MySQL documentation about Binary Logging of Stored Programs. The MariaDB manual also has good documentation on binary logging." at the bottom of the page, but those documents are written for people who know what they're doing... which I clearly do not!

On the wiki page (http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements), it says:

If your version of MySQL is greater than 5.1.6 you will need the following for all typical uses of CiviCRM 4.3+ including installing extensions:

Code: [Select]

NOTE: The extra TRIGGER permission.-- Assuming a database called "civicrm" and a user called "civicrm_user"
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';

That's the bit I copied (and changed to use my info/settings).