I know it's late.
So Here's the different permutations I've tried on whatcha gave me.
-----------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.16-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use zimbra
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
mysql> use zimbra
Database changed
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
mysql> exit
Bye
---------------
So either my table doesn't exist, or I'm doing it wrong
PS-You like family guy?