MySQL Stored Procedures

All MDDHosting clients can use MySQL stored procedures and routines on their web hosting accounts.

To use stored procedures, you should first create a database and add a database user to it. Make sure that you select the "ALL PRIVILEGES" option when you add the user to the database.

Then you should open cPanel > PhpMyAdmin, navigate to your database, open the SQL tag and paste the stored procedure code.

Comprehensive details on MySQL stored procedures and their syntax can be found in the MySQL5 official documentation:

  • 189 Users Found This Useful
Was this answer helpful?

Related Articles

Ordering Hosting - Domain Registration and Transfer Options

When ordering a hosting plan you will be given 3 options:   Register a new domain. Transfer...

Why does it take a few hours to provision my VPS?

When we provision a VPS for a client we take the time up front to secure and optimize that VPS...

What nameservers should I use?

All of our shared, reseller, and semi-dedicated services use the same DNS cluster and the...

How quickly will my Virtual Private Server be provisioned?

We do our best to provision Virtual Private Servers within 1 to 2 hours from the time that the...

Setting up Private Nameservers on a domain registered with MDDHosting

The steps below outline the process for setting up private nameservers on a domain registered...