I have set host value to use a remote IP in my env.php file. But I got an error saying "Access denied for user 'manager'@'localhost'(using password: YES)"

why Magento 2 still says I'm using the localhost?

I have tested the username and password for mysql, so I'm sure they are correct. And the mysql user I used have remote access

I have cleared the Cache, di, generation folder.

1 Answer 1


It already happened here, maybe your database doesn't have permit to this user, to check use this command below changing the user (-u parameter), password (-p parameter), host (-h parameter) and database (-D parameter):

mysql -uroot -proot -h -D database

If it doesn't work, try access with your root user to check.

  • Sorry, i edited my comments. your command works find for me if I use root. But when if I use root login in env.php. it still give me the same error. Apr 10, 2017 at 14:47
  • Try to update your Magento to 2.0.13 Apr 10, 2017 at 14:52
  • I'm already using 2.1.0 Apr 10, 2017 at 15:08
  • So update to 2.1.15 Apr 10, 2017 at 16:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.