Permissions to create and run stored procedure

Question

I want to create a user in Mysql and I want that user to have permissions to create and run stored procedure. I using mysql workbench. Can you please guide me how to create user from workbench or through command-line with stored procedure permission. Workbench gives various options for permission as shown in below image, which options must be selected for have permission to create and run SP

Answer 1

Try this commands:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; 
GRANT ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON *.* TO 'username'@'localhost' ;