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.
Post a Comment

Featured Post

Setup Chinese Input Method in Ubuntu 17.10 Artful

sudo apt install ibus-sunpinyin After either of those commands do not forget to restart the IBus daemon ibus restart You might need t...