September 12, 2010

Do you allow MySQL Triggers on Shared Hosting Account

We are runnig MySQL 5.0.x on our shared and reseller hosting servers. In order to use TRIGGERS with MySQL 5.0.x, you must have the SUPER privileges. For security reasons, we do not grant this to regular users.

We do plan to eventually upgrade to MySQL 5.1 and it will be a simple matter of enabling the TRIGGER privilege per-user. As if now, for security reasons, we will not be enabling any sort of workarounds to enable TRIGGER privileges. TRIGGER will not be available on shared reseller servers until MySQL 5.1 is installed.

We will suggest you to have a look at our economy VPS packages, where you will be able to escalate the privilages with the latest version of mysql installed.