Change the stored Procedure Definer

 Change Views DEFINER without ALTER VIEW:

UPDATE `mysql`.`proc` p SET definer = ‘root@localhost’ WHERE definer=’root@foobar’ AND db=’whateverdbyouwant’;

Turn off variable automatic_sp_privileges, to Preseve Execute permissions for MySQL procedure with alter procedure.

set global automatic_sp_privileges  = 0;