MySQL Forums
Forum List  »  Stored Procedures

The user specified as a definer ('root'@'%') does not exist
Posted by: Yash Ganthe
Date: January 10, 2021 12:29AM

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(

Options: ReplyQuote


Subject
Views
Written By
Posted
The user specified as a definer ('root'@'%') does not exist
150
January 10, 2021 12:29AM


Sorry, only registered users may post in this forum.

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.