MySQL Stored Procedure Permissions
Your second attempt is the right approach: GRANT EXECUTE ON PROCEDURE myDB.spName TO ‘TestUser’@’localhost’; but if that is not working, verify … a) you (the user from which you are running all these command) have grant rights [i.e WITH GRANT OPTION]. If you are root, then you have grant rights. b) the user exists to … Read more