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.
Code:
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.