Please note that this function is an aspect of web design/coding. Therefore, you must supply the working MySQL statements. Support from Osirion 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 email support@osirion.co.za 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.