None of those threads give a clear answer, possibly because nobody knows the answer.
Ok, here goes.
cPanel + PHPMyAdmin messes up a lot of things.
When you are in PHPMyAdmin, you are as user 'cmalvido' .
Your scripts will run as user cmalvido_yadda or similar. But cPanel will not let you give Execute privileges to him.
And cmalvido apparently cannot GRANT them in PHPMyAdmin.
So, from what I have gathered ....
Create a PHP (Python/Perl) script that has user cmalvido_yadda sign on to database cmalvido_database and create the Strored Procedures you want.
Make sure cmalvido_yadda has CREATE_ROUTINE permissions on the database.
Run the script from the web.
Remove CREATE_ROUTINE permissions and/or disable the script.
MySQL automatically grants EXECUTE privileges to the creator of the Stored Procedure.
No guarantees. Has not been tested. Try out on a dummy DB first if you are worried.
__________________________
If you try this, please post back with the results. Good or Bad.