Could not create a trigger

[kkvgbg]

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

[kkvgbg]

Bah! I just checked with my host and they don't allow TRIGGERs, so am looking for a workaround. Possibly I'll just have to host the DB somewhere else, so recommendations are welcome. (I'm looking through the service provider list https://civicrm.org/providers but would appreciate any suggestions)

Cheers
Mateusz

[Hershel]

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.

[kkvgbg]

Good morning,

Thanks for the comment - I hadn't decided on CiviCRM when we moved host recently, so didn't think of checking this. Also, the host (Binero.se) is generally well regarded in Sweden so I assumed they'd be able to offer whatever. Silly of me.

Cheers
M