Magento 2 command line utility saying “Access denied for user”

Question

My magento 2 installation is working fine, but when I go to terminal and try to use any command, for example image resize, it is giving me following

[Zend_Db_Adapter_Exception]
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

As noted, front end is working fine.

Quan Le · Accepted Answer · 2017-06-18 06:30:02Z

1

You are on localhost or on live server.

Using password:NO means you are trying to connect to mysql without password, so unless your database doesn't have a password,

Or you didn't updated your password field in env.php

In Magento 2.0, the configuration is in the same directory (app/etc/) and the file is env.php. The file path is:

app/etc/env.php

In this file, a number of key things are set, including the database connection information:

'host' => 'localhost',
'dbname' => 'magento2database',
'username' => 'some-username',
'password' => 'some password here',

Quan Le

1,6841 gold badge10 silver badges18 bronze badges

answered Jun 18 '17 at 2:58

inrsaurabh

1,6161 gold badge16 silver badges47 bronze badges

This is normally the cause - however this is happening to me with the correct details in env.php. – ol'bob dole Aug 15 '17 at 9:53

add a comment |

1 Answer 1