Sep 14, 2018

How to fix MySQL Error 'The user specified as a definer does not exist' on query

Check your definer:
select definer from mysql.proc ;

Update your definer:

UPDATE mysql.proc SET definer = 'my_new_user@your_host' WHERE db = 'your-datatbase';

If your user doesn't exist, then of course, you need to create the user.