MySQL Stored Procedures, triggers

Please note that this function is an aspect of web design/coding. Therefore, you must supply the working MySQL statements. Support from HostGator is limited to ensuring MySQL works and the stored procedures exist.

Shared and Reseller

We currently allow you to create, execute, alter, and view stored procedures on your databases. In order to grant these options...

1. Login to cPanel and click the "MySQL Databases" icon.
2. Under the "Add User To Database" section, select the User and the Database you want to create the grants for, then click the "Add" button.
3. On the following page, set the grants required for stored procedure manipulation.

We can enable trigger privileges for your database, simply contact us via phone or Live Chat with the database, database user, and the tables that you require the permissions on.

Windows Shared

For MSSQL, you can implement these procedures on your own. Documentation on stored procedures can be found here.

For MySQL, you can implement these procedures on your own. Documentation on stored procedures can be found here.

VPS and Dedicated

You can implement these procedures on your own. Documentation on stored procedures can be found here.