Should I change the ispconfig mysql password using
update user set Password=PASSWORD('mynewpassword') WHERE User='ispconfig';
Do I need to update an ISPConfig file somewhere when I do?
Thats the wrong way.
You should set back the password in mysql to the old value as it is stored in many files. You find the original password in the file /usr/local/ispconfig/interface/lib/config.inc.php