I use MySQL version 8.0.18
select @@version ;
I have many stored procedure. Two of them have the following properties
SELECT routine_name, definer
WHERE ROUTINE_TYPE = 'PROCEDURE'
and routine_name in ('save_stop', 'get_stops')
When I run:
set @id := 0 ;
call save_stop(@id,'Kamat Classic',NULL,15.475872602713768,73.81208726755833,2,NULL,2) ;
This results in
ER_NO_SUCH_USER: The user specified as a definer ('root'@'%') does not exist
But this works
What is the reason behind the definer error? All procedures are defined with simple SQL such as :
drop procedure if exists save_stop//
create procedure save_stop(
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.