Prejmem napako “General error: The user specified as a definer does not exist” ali “You might be lacking the necessary privileges to edit this routine”. Kaj storiti?

Za prejeto napako:

General error: The user specified as a definer (‘DATABASE_USERNAME‘@’localhost’) does not exist IN /home/….

ali

Error in processing request: No routine with name `FUNCTION_NAME` found in database `DATABASE_NAME`. You might be lacking the necessary privileges to edit this routine.

Rešitev je, da pred uvozom baze pri “CREATE DEFINER” nujno nastavite pravilno ime uporabnika za povezovanje na dotično bazo:

CREATE DEFINER=`DATABASE_USERNAME`@`localhost` FUNCTION ….

DATABASE_USERNAME: vpišite pravilno uporabniško ime za povezovanje na bazo.