Nov 5, 2017

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 = '[email protected]_host' WHERE db = 'your-datatbase';

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