Manually Reset MySQL Password

MySQL password reset manually

---

---

Problem

MySQL, database connection failure due to invalid credentials. User Zimbra not able to authenticate database connection.

Error:

Log file:/opt/zimbra/log/mailbox.log

WARN  [main] [] misc - Could not establish a connection to the database.  Retrying in 5 seconds.
com.zimbra.common.service.ServiceException: system failure: getting database connection
.
.
Caused by: java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'zimbra'@'localhost' (using password: YES)