terrydiederich2
1/10/2019 - 2:59 PM

Definer doesn't exist

--When restoring database to local drive, You may get an error saying 
--the user set up as DEFINER in a stored procedure doesn't exit. Run 
--this command to fix the error:

    GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
    FLUSH PRIVILEGES;