MySQL Trigger

[kb0kqa]

I'm learning MySQL as I go... I'm interested in using "CREATE TRIGGER", but the database (mysql.nozonenet.com) returns:

ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation

Is this telling me that I cannot do this as at all due to Steadfast settings, or that I need to make a change somewhere to my account?

Thanks.

[Kevin]

This is something that requires an administrative MySQL server account to do. Unfortunately we cannot offer such features to customers on shared hosting.

[kb0kqa]

Thanks for the response!

[manilodisan]

The only host I found so far to support mysql triggers on shared packages is at placehost.net. I hope more will come. This is probably because hosting providers wait for plesk or cpanel to support such versions of PHP/MySql and those two are moving slower than anything else. PHP 5.2.9 came out recently and a lot of bugs were fixed yet nor cpanel or plesk supports this version. Mysql releases 5.4 soon so triggers will no longer need the super user privilege to be added, but, as always, how much time will the control panels need to support it?