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;