[KevinH]

Sorry I should have given the exact commands to get to the logger db.

mysql -P 7307

use zimbra;
update user set password=PASSWORD('pass') where user like 'root%';
flush privileges;