DELIMITER $$

DROP PROCEDURE IF EXISTS `dbname`.`sp_sample` $$

CREATE PROCEDURE `dbname`.`sp_sample` ()
SQL SECURITY DEFINER or SQL SECURITY INVOKER
BEGIN

........... SQL code goes here ...........

END $$

DELIMITER ;