Re: ERROR 1142 (42000): TRIGGER command denied to user

[Alex Matthews]

Thanks very much for the pointer! Searching for the error on Google simply suggests the missing GRANT 'SUPER', which I had.

So for anyone needing the actual syntax its as follows: -

GRANT TRIGGER ON *.* TO ucac_joomla_v2@'localhost' IDENTIFIED BY '[USER PASSWORD]';