select * from mysql.proc WHERE db='dbname'; update mysql.proc set DEFINER='root@%' WHERE db='dbname';