To use MySQL5 with Tiki, you need to use Tiki version 1.9.3 or later.
"The following are new reserved words in MySQL 5.0: ASENSITIVE, CALL, CONDITION, CONNECTION, CONTINUE, CURSOR, DECLARE, DETERMINISTIC, EACH, ELSEIF, EXIT, FETCH, GOTO, INOUT, INSENSITIVE, ITERATE, LABEL, LEAVE, LOOP, MODIFIES, OUT, READS, RELEASE, REPEAT, RETURN, SCHEMA, SCHEMAS, SENSITIVE, SPECIFIC, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, TRIGGER, UNDO, UPGRADE, WHILE."
Tiki had been using "reads" as a field in its DB structure. This works fine in Mysql 3 & 4.
A consequence of this: if you upgrade your Tiki, you need to run the database upgrade script (ex.: 1.8 to 1.9.sql) please note : if upgrading from 1.9.3 to 1.9.4, you still need to run this script, which is designed to be ran multiple times.