MySQL stored procedure and permissions

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.

Leave a Reply

Register to Get FREE Offers

Why Pay for Software when you can GET it for FREE

JOIN US TONIGHT!