CiviCRM Community Forums (archive)

Good afternoon all!

My CiviCRM install hit a snag when I got a "Could not create a trigger" warning during install - it's the only remaining error, and I'm confounded as to what to do now. I know next to nothing about SQL, so might be poking the wrong things with my noob-stick, and would appreciate suggestions.

I've read this part in the guide: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements
and I've tried to run the query

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';

through PHPmyadmin, substituting "civicrm" "civicm_user" and "localhost" with my settings (which show green in the install window, so ought to be correct) but get the error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'civicrm.* TO 'civicrm_user'@'localhost' IDENTIFIED BY 'realpassowrdhere'' at line 1.

I've tried leaving the "localhost" in place of the server-name, and I've tried with and without the accents (the ' signs around the names) but get syntax errors regardless. I've read some posts that TRIGGER creation must be enabled by the host, but as far as I can tell this is a syntax error, not a permission error. (yet)

I've also found this post http://forum.civicrm.org/index.php/topic,31348.msg134499.html#msg134499 - but it repeats the advice from the official documentation and results in the same error as above.

In this post: http://forum.civicrm.org/index.php?topic=29319.0 there's advice on pasting
log-bin-trust-function-creators = 1
into my.cnf, but I've yet to find that file (if I can access it at all - I might have to check with the host).

Is this latter suggestion the simplest way to go about solving this? I'd appreciate your advice.

Kind regards
Mateusz

Generally speaking, the main recommendation given on these forums is to consult that list. You would have to ask the various providers if they allow remote connections to MySQL if you plan to host only the database remotely.