Site down: main.CRITICAL: SQLSTATE[28000] [1045] Access denied for user '(removed)'@'localhost'

[usman_hussain]

The following is the complete error in the log:

main.CRITICAL: SQLSTATE[28000] [1045] Access denied for user '(removed)'@'localhost' (using password: YES) {"exception":"[object] (Zend_Db_Adapter_Exception(code: 1045): SQLSTATE[28000] [1045] Access denied for user '(removed)'@'localhost' (using password: YES) at /home/(removed)/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144, PDOException(code: 1045): SQLSTATE[28000] [1045] Access denied for user '(removed)'@'localhost' (using password: YES) at /home/(removed)/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:128)"} []

I have tried many solutions but nothing worked, can anyone help me with this?

[Manthan Dave · Accepted solution]

Hi @usman_hussain

Looking at the error log you have posted , the issue is either your database user is removed or database user 's password is changed  and that's the reason its not accessible to the database !

so do one thing either rest the existing database user 's password and add it in env.php file or create a new database username and password both add add it in env.php file 

Right now also this details is there in env.php file so you need to replace this details with newer database username and password 

that will help you to resolved this error !

[usman_hussain]

Changed the password in etc/env.php. Site is working now.
Thank you for this kind help.
Cheers.

[Manthan Dave]

Hi @usman_hussain

Glad to know that its worked for you !

Happy to help and keep helping