Need a web host that allows MySQL triggers on shared accounts

Question

Does anyone have experience with or know of a web host that allows the use of MySQL triggers on shared (read "cheap") accounts?

I currently use Surpass Hosting and they told me this was a feature they won't support for security reasons.

Update

I've checked with bluehost, Host Monster, and DreamHost and none of them support triggers.

This is all due to triggers requiring the SUPER privilege. MySQL 5.1.6 will implement a TRIGGER privilege, which should alleviate the issue.

Answer 1

I think most hosts that have mysql 5 or later will support triggers, but i have actually not used them with mysql myself.

Ive use Dreamhost for many years and alwasy been happy with them (http://dreamhost.com or http://www.dreamhost.com/r.cgi?redpirk to give me credits ;)

if you send me short code snippet, i can test.

Answer 2

i've used nativespace.co.uk (affiliate link). very helpful service and setup triggers for me even though there wasn't an option to do it on the control panel. Josh

Answer 3

The only host I found so far to support mysql triggers on shared packages is placehost