mysql error 1356 references invalid table(s) or column(s) or function(s) or definer/invoker of view

Long story short, I recovered a mysql backup from my old LAMP server and afterwards I kept getting a view error when editing users. After many hours of trying to find a fix I was about to dump and rebuild the mysql.user schema since it was what was messed up since it had old user rights and everything from my old server. I googled for hours and hours trying to fix it finally what did it was one simple command….

mysql_upgrade --force

boom user view worked
boom I can edit and add users again through the webmin interface.
Thanks for reading hope this helped!

Leave a Reply