I am having issues with mysql and zmlogger. My system went down hard due to a power outage last week and I noticed that the stats were not updating. I found out the hard way when attempting to trace a message using zmmsgtrace.
In any event, I followed the 'quick' resolution and stopped zmlogger, removed /opt/zimbra/logger/db, and ran /opt/zimbra/libexec/zmloggerinit. However, the result was that the passwords were reset.
Okaaaay, so I followed the wiki on <a href=http://wiki.zimbra.com/index.php?title=Resetting_LDAP_%26_MySQL_Passwords >resetting the mysql password</a>, but when I attempt to connect [logmysql mysql -D zimbra_logger -P 7307], I still get a message about a failed password and am unable to get to a prompt to reset.