Mysql rename procedure

Syntax:

UPDATE `mysql`.`proc`
SET name = '<new_proc_name>',
specific_name = '<new_proc_name>'
WHERE db = '<database>' AND
name = '<old_proc_name>';

Example:

UPDATE `mysql`.`proc`
SET name = 'spcountrynew',
specific_name = 'spcountryNew'
WHERE db = 'XXX' AND
name = 'spcountry';

Result: