We are getting the error while creating procedure in MySQL on windows
#1044 – Access denied for user ‘my_user’@’%’ to database ‘my_dataabse’
For this , web hosting have to give CREATE ROUTINE, ALTER ROUTINE, and EXECUTE rights to database and database user.in simple way you can say that you need the SUPER privilege for this operation.
We added another username to the database as MySQL keeps track of which account was used to create each stored procedure and we have to allows that account permission to execute it.