[KevinH]

Your on the right track. Take the password from:

zmlocalconfig -e -f mysql_logger_root_password='<>';

Then use:

update user set password=PASSWORD('<>') where user like 'root%';
flush privileges;

To reset it.

Restart logger and hope for the best.