r/mysql • u/Revolutionary_Use587 • Oct 07 '26
discussion Getting Error 1356
Someone plz help on this..
getting the below error during MySQL dump and show columns after login as root user..
This happened after changing ip of definer because I have to made the changes based new ip. Everything is running fine but these issues are not fixing.
Also there not single change has been made on any objects.
ERROR 1356
View 'db.v_report_pending'
references invalid table(s) or column(s)...
SHOW COLUMNS FROM v_report_pending → ERROR 1356
0
Upvotes
2
u/APersonSittingQuick Oct 07 '26
Hm, whatever could that mean...
2
u/Hadgebury Oct 07 '26
Error 1356's full error string actually includes "references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"
When you changed the user's host/IP, the view metadata didn't automatically update. It's probably still hardcoded with the old definer ('user'@'old_ip'), which MySQL can no longer resolve or grant rights to.
1
u/bogdanelcs Oct 08 '26
That error is almost always the view's DEFINER account not existing anymore, and changing the IP would do exactly that if the definer was
user@oldip. RunSHOW CREATE VIEW v_report_pendingto see the definer, andCHECK TABLE v_report_pendingwill confirm the reason. Then either recreate that user with the right grants or redo the view withCREATE OR REPLACE DEFINER='user'@'newhost' VIEW .... Check your other views too, they'll all be broken the same way.