How to enable and execute stored procedures in mysql

Incase you want to execute a stored procedure , you will face problems like root access needed.

To over come that problem we need to run a query to grant access to execute a stored procedure in mysql.

Following is the query.

grant all on *.* to ‘root’@’%’ identified by ‘password’ with grant option;

To execute a Stored procedure in mysql , we need to use CALL function like follows.

Suppose the name of the stored procedure is get_emp_name ,then to run this procedure

just write the following query
CALL get_emp_name()
To execute a parameter based stored procudure ,you can write following query like follows.
CALL get_emp_name(1);