Database procedures, also known as “procs”, are stored SQL code statements which can be reused when needed over and over again. You can imagine them as functions in most of the programming languages. Parameters can be submitted towards these procedures so they can parse information based on dynamic values. Some of the tasks they can perform are access control, data validation, and network traffic reduction between the MySQL client and the MySQL server. In this tutorial, we are going to go over how you can create procedures using the phpMyAdmin functionality in your cPanel. Let’s get started!
Before you can access the PHPMyAdmin functionality, you need to log into your cPanel account with us. To do so, please check our tutorial on How to access the cPanel service.
Once logged in, please navigate to the “Database” section and click on the “phpMyAdmin” icon.
Clicking on the result redirects you to the “PHPMyAdmin” feature. In the left sidebar, you can see a list of all your databases.
Please select the database for which you want to create a procedure by clicking on it.
Once you have selected the database, all its tables are generated in the middle of the screen.
From the tab bar on top, please click on the “Routines” tab. This action takes you straight to the page, which allows you to add a database procedure.
On the top, you can see the “Routines” section where all the existing procedures are shown. If there are no procedures created like in our case - it is empty. To add a procedure, please click the “Add routine” button located under the “New” section.
This action shows a popup window, which allows you to configure your new database procedure.
Bellow, we are going to cover the majority of the options provided in the popup window.
After you have configured your procedure, please press the “Go” button to create it.
We have prepared a really simple example of what a procedure might look like. Please check the screenshot below:
When created, this procedure is listed on the left side of the screen, right under the database you selected when creating it.
It is also shown inside the “Routines“ tab, under the “Routines” section we went over in the previous paragraphs.
On the row where the procedure is located, you can notice 4 buttons. Let’s go over all of them.
And there you have it! This is the way you can use phpMyAdmin to create procedures for your database. If you are facing any technical issues with this functionality, please do not hesitate to contact our technical support staff over the ticking system in your Client Area.
Sebahat is a young and bright person who had become an invaluable part of our team. Started as a Customer Care Representative who quickly evolved into a Tech-savvy well familiar with every support layer of the company. Driven by the aim to constantly improve our customers’ experience she is committed to enhancing the extraordinary support we deliver.