[techmeisterv]

I have the same problem but when I followed the commands and this is what I got, any ideas why it can't connect to the MySQL server?:

* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
* Changing mysql zimbra user password
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
**** PASSWORD CHANGE FAILED

Originally Posted by brian

running zmloggerinit most likely borked your logger install. You are going to have to manually find and kill the mysql logger process, delete the logger db and rerun zmloggerinit.

host: su - zimbra
host:~ zimbra$ ps -auxw | grep my.logger | grep -v grep | awk '{print $2}' | xargs kill
host:~ zimbra$ rm -rf logger/db
host:~ zimbra$ libexec/zmloggerinit 
* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
* Changing mysql zimbra user password
* Changed zimbra mysql user password

After that edit libexec/zmlogger and make the changes from the previous post and restart everything.