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...
- Login to cPanel and click the "MySQL Databases" icon.
- 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.
- 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.