Browse by Topic Pre-Sales & Policies Hosting Guide cPanel WebHost Manager (WHM) Plesk SSL Certificates Specialized Help Affiliates Helpful Resources Account Addons Billing System HostGator Blog HostGator Forums Video Tutorials Contact Us Interact and Engage

HostGator.com » Support Portal

[?]
Support Portal Home » Specialized Help » Technical » 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. 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 email support@hostgator.com with the database, database user, and the tables that you require the permissions on.

VPS and Dedicated

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

Was this article helpful to you?

Article Comments

MK
Cannot grant a user "Execute" permission for a particular database. After granting all privileges, the page still shows "Execute" as unchecked. Any idea why?
Posted: December 26, 2010
HostGator
Thank you for your comments. Just a quick reminder that the comments on this page are not monitored by technical support staff, and that for support issues, it is best to contact us by live chat, phone or email so we can assist you right away.

Although comments are not monitored by technical support staff, they are moderated and read by technical writers. Comments will need to be approved by a moderator before appearing.

Our technical writers do read the comments periodically for the purposes of updating the articles, and do appreciate your feedback, suggestions and corrections to the articles themselves, as well as any suggestions or tips for readers of this article. However, support questions posted here are not guaranteed to be replied to in a timely manner or at all. For support issues, it is best to contact our support staff instead by live chat, email or phone.

Posted: December 13, 2011 (Global Reply)
Your comments help us keep the knowledge base updated. This is not a medium for support. If you have questions or need help, please contact us via email, phone or live chat for fast assistance.

Post Comment