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….
boom user view worked
boom I can edit and add users again through the webmin interface.
Thanks for reading hope this helped!