Change the stored procedure definer|How to change mysql store procedure definer| How to update mysql all stored procedure definer.

To Check the definers:

show procedure status;

To update all stored procedure definer:

Syntax:

UPDATE `mysql`.`proc` p SET definer = 'user@%' 
WHERE definer='root@%'

Example:

UPDATE `mysql`.`proc`  SET definer = 'root@localhost' 

UPDATE `mysql`.`proc`  SET definer = 'root@localhost'  where db='DbName'