Manually Reset MySQL Password: Difference between revisions
Line 10: | Line 10: | ||
: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. com.zimbra.common.service.ServiceException: system failure: getting database connection . . Caused by: java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'zimbra'@'localhost' (using password: YES)</pre> | :<pre>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)</pre> | ||
====Solution==== | |||
Reset MySQL password by manually updating MySQL configuration file. | |||
'''Step 1:''' | |||
* Stop the mysql service. [Run as Zimbra] [<code>su - zimbra</code>] | |||
<pre>$ mysql.server stop</pre> | |||
'''Step 2:''' | |||
* Modify the <code>/opt/zimbra/bin/mysql.server</code> to start the MySQL with skipping the grant tables (Skipping authentication). [Run as ROOT] | |||
From | |||
<pre>--ledir=/opt/zimbra/common/sbin < /dev/null > /dev/null 2>&1 &</pre> | |||
To | |||
<pre>--ledir=/opt/zimbra/common/sbin < /dev/null > /dev/null 2>&1 & --skip-grant-tables &</pre> |
Revision as of 08:59, 13 November 2022
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)
Solution
Reset MySQL password by manually updating MySQL configuration file.
Step 1:
- Stop the mysql service. [Run as Zimbra] [
su - zimbra
]
$ mysql.server stop
Step 2:
- Modify the
/opt/zimbra/bin/mysql.server
to start the MySQL with skipping the grant tables (Skipping authentication). [Run as ROOT]
From
--ledir=/opt/zimbra/common/sbin < /dev/null > /dev/null 2>&1 &
To
--ledir=/opt/zimbra/common/sbin < /dev/null > /dev/null 2>&1 & --skip-grant-tables &