1. Knowledge Base
  2. >
  3. Results
  4. >
  5. MySQL Stored Procedures, triggers

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. To grant these options, follow the steps below:

  1. Login to cPanel.
  2. In the Databases section, click the MySQL Databases icon.

    HostGator cPanel phpMyAdmin

  3. Locate the MySQL Users section of the MySQL Databases tool.
    To quickly find this section, click Jump to MySQL Users.

    MySQL Jump

  4. 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.

    MySQL Add User

  5. On the following page, set the grants required for stored procedure manipulation and then click Make Changes.

    MySQL Add Privileges

We can enable trigger privileges for your database; 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.