SQLSTATE[HY000] [1045] Access denied for user

meanbee / docker-magento2

🐳 Docker containers with all required Magento 2 dependencies installed available as FPM through Nginx and CLI

MIT License

455 stars 245 forks source link

SQLSTATE[HY000] [1045] Access denied for user #172

Closed leonmex closed 1 year ago

leonmex commented 4 years ago

Hello is not possible to execute setup:upgrade I get always SQLSTATE[HY000] [1045] Access denied for user the root user is % assigned. someone knows how to solve this problem.

joesken commented 4 years ago

Hi - some things to try maybe to get to the bottom of the issue:

Can you ping the db container from FPM container?
Can you log on to the database from the FPM container? e.g. mysql -u usernname -p -h db and put in the password when prompted.
Double check the host, username and password values are correct in your env.php file?

leonmex commented 4 years ago

Hello @joesken yes ping:

After install all again the setup:upgrade / access to the database works.

But varnish still not use the port 80 and I need to set manually the port for varnish in the shop.local:port for get the access. any clue about this issue.

Best.

joesken commented 4 years ago

Hi,

I'm not clear what you mean by "need to set manually the port for varnish in the shop.local:port" - where are you talking about here?

Depending on what system you are using you may need to edit the docker-compose file to explicitly map the ports e.g. 80:80 (I think be default on the Mac setup this get's linked automagically).