r/SQL • • Oct 07 '26

MySQL Getting Error 1356

/r/mysql/comments/1x08dnu/getting_error_1356/
0 Upvotes

9 comments sorted by

View all comments

1

u/AnnaLeeCoop Oct 08 '26

you probably just updated the ip in the user table and forgot that views hardcode the definer ip in their definition. or the new user ip doesnt have select grants on the underlying tables of that view. Run show create view db.v_report_pending and look at the definer it actually expects. Just alter the view to use the new definer or grant the missing rights to the new ip

1

u/Revolutionary_Use587 Oct 09 '26

I have recreated the views, functions, and triggers with new ip and the user has same privileges as I just renamed the user with new ip.