When I run my procedure with different user with definer
"show processlist " in host name I got ‘%’ with some ports.
eg.
id user host
16 root %:31514
Any suggestion.
Hi,
Can you send the procedure you are using, and steps to reproduce? Do you get correct IP addresses if you call the procedure with the same user as the definer?
Also, what exact version are you using?
SHOW VARIABLES LIKE ‘ver%’;
1 Like
@Agustin_G Thanks for the response.
Reproduce:
When I run/execute a procedure which have definer as ‘root’ from another users it shows same.
MySQL version 8.0.22.
1 Like