The user specified as a definer ('root'@'%') does not exist
I use MySQL version 8.0.18
-- 8.0.18
select @@version ;
I have many stored procedure. Two of them have the following properties
SELECT routine_name, definer
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
and routine_schema='raloa2'
and routine_name in ('save_stop', 'get_stops')
;
This returns:
get_stops root@localhost
save_stop root@localhost
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
call get_stops(2);
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(
Subject
Views
Written By
Posted
The user specified as a definer ('root'@'%') does not exist
1487
January 10, 2021 12:29AM
515
January 10, 2021 12:23PM
Sorry, you can't reply to this topic. It has been closed.
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.