Update MYSQL Definers - All at once

 show procedure status where Db <> 'DatabaseName' and Definer = 'localuser@%';

 

SET SQL_SAFE_UPDATES = 0;

update mysql.proc set definer='localuser@%' where definer='root@localhost' and db = 'DatabaseName'        ;

SET SQL_SAFE_UPDATES = 1;