Manually Reset MySQL Password: Difference between revisions

(Created page with "=MySQL password reset manually= <hr> {{KB|{{WIP}}|{{ZCS 8.8}}|{{ZCS 9.0}}}} <hr> __FORCETOC__ ====Problem==== User Zimbra not able to authenticate MySQL. :Error: :Log file:...")
 
Line 5: Line 5:
__FORCETOC__
__FORCETOC__
====Problem====
====Problem====
User Zimbra not able to authenticate MySQL.
MySQL, database connection failure due to invalid credentials. User Zimbra not able to authenticate database connection.


:Error:
:'''Error:'''
:Log file:<code>/opt/zimbra/log/mailbox.log</code>
:Log file:<code>/opt/zimbra/log/mailbox.log</code>
:<pre>WARN  [main] [] misc - Could not establish a connection to the database.  Retrying in 5 seconds.&#10;com.zimbra.common.service.ServiceException: system failure: getting database connection&#10;.&#10;.&#10;Caused by: java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'zimbra'@'localhost' (using password: YES)</pre>

Revision as of 08:38, 13 November 2022

MySQL password reset manually


   KB 24485        Last updated on 2022-11-13  




0.00
(0 votes)

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)
Jump to: navigation, search