To create a Procedure in phpMyadmin, you must first access phpMyadmin through cPanel.

\
![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdkZPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--3df31eb22f17e76f2811465c07d1627871911b81/Screenshot%20(8).png)

1. Click on your database which is located on the left side, after that, click on "**Routines**".


![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdkpPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--860250d9f3db89f3cd7b586602c92662e0e70ce2/image%20(71).png)

1. Then click on "**Create new** **Routine**".


![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdk5PIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--029a77fdc7e1bcf68576976e3888d6cd008719e4/image%20(72).png)

1. Fill in the data and parameters and click "**Run**".


![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdlJPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--72013b09d39902332d0405ba4dff1e5243d66257/image%20(73).png)

1. After that, the created Procedure will be displayed, as shown in the following image:


![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdmRPIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--318ca87408d43b152111d7b20aa173801640acef/image%20(74).png)