MySQL Forums
Forum List  »  Triggers

Re: trigger with definer root@% vs root@172.18%
Posted by: Hélio Barbosa
Date: June 21, 2019 05:54AM

the trigger code is just a insert...

my problem is with trigger definer parameter that is root@%, but my user is root@172.18%

but the error is:

update `os` set `dt` = '2019-06-19 14:49:06', `user_id` = 8 where `id` = 15260291
> 1449 - The user specified as a definer ('root'@'%') does not exist
> Time: 0,085s

Options: ReplyQuote

Written By
Re: trigger with definer root@% vs root@172.18%
June 21, 2019 05:54AM

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.