Knowledge Base

Get Expert Website Hosting

Choose website reliability and expertise with SiteGround!

Home / Database Support / Advanced MySQL Features / How to use MySQL stored procedures and routines?

How to use MySQL stored procedures and routines?

Last update: Aug 13, 2025

MySQL stored procedures and stored routines are supported after MySQL 5.

All SiteGround 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 phpMyAdmin in Site Tools, navigate to your database, open the SQL tab and paste the stored procedure code.

Comprehensive details on MySQL stored procedures and their syntax can be found in the MySQL v5 official documentation here.

Share this article