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. To grant these options, follow the steps below:
- Login to cPanel.
- In the Databases section, click the MySQL Databases icon.
- Locate the MySQL Users section of the MySQL Databases tool.
To quickly find this section, click Jump to MySQL Users.
- 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 and then click Make Changes.
