make migrate throws error in SQL about docker-nginx-php-laravel HOT 4 CLOSED

I've also changed the host from 127.0.0.1 to localhost. Neither has made a difference.

from docker-nginx-php-laravel.

We are using host as "mysql" and it is working properly inside CI and on local PC. Maybe you have changed something on your local PC or environment. Also please make sure that all docker containers are running on your local PC.

from docker-nginx-php-laravel.

Thanks @dimadeush but I've confirmed it is running. In fact i can connect to it via the port 33061 from my Mac. I kept the ports defined in the yml files provided in the repo as - 33061:3306.

It is part of the laravel network as well.

In fact the initial run even performs the mysql initdb.sql queries I have in there to build the database and basic table schemas.

One thing I noticed that's different is that nginx, laravel, supervisor and my redis configs all say image: ${COMPOSE_PROJECT_NAME}-xxxx:latest (where xxxx is the name of the config). But the mysql entry just says mysql:8.0. I tried adding the ${COMPOSE_PROJECT_NAME}- prefix but it threw an error so undid that.

It's acting like the migration is trying to use a login that isn't correct (like not the root user). But my env shows:

DB_HOST=localhost
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=secret

That's the data I connect to the mysql db with on my mac so I know those credentials work.

I'm stumped.

from docker-nginx-php-laravel.

Oh duh. I just realized what you mean. DB_HOST should have been "mysql"... It's working thanks!!

from docker-nginx-php-laravel.