php - Laravel Sail - Migration are working but can't register new user

one text

I've set up a new laravel project and here's the step I followed :

  • install laravel on docker using

     curl -s "https://laravel.build/example-app" | bash
    
  • changing mysql port as 3306 is already used in my machine. Files have changed

.env file

DB_CONNECTION=mysql
DB_HOST=0.0.0.0
DB_PORT=4306
DB_DATABASE=example_app
DB_USERNAME=sail
DB_PASSWORD=password

docker-compose file (mysql container section)

mysql:
    image: 'mysql/mysql-server:8.0'
    ports:
        - '${FORWARD_DB_PORT:-4306}:3306'
    environment:
        MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
        MYSQL_ROOT_HOST: "%"
        MYSQL_DATABASE: '${DB_DATABASE}'
        MYSQL_USER: '${DB_USERNAME}'
        MYSQL_PASSWORD: '${DB_PASSWORD}'
        MYSQL_ALLOW_EMPTY_PASSWORD: 1
    volumes:
        - 'sail-mysql:/var/lib/mysql'
        - './vendor/laravel/sail/database/mysql/create-testing-database.sh:/docker-entrypoint-initdb.d/10-create-testing-database.sh'
    networks:
        - sail
    healthcheck:
        test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
        retries: 3
        timeout: 5s
  • build and run container

    ./vendor/bin/sail up

  • run 1st migration

Everything works fine at this point.

Then I install breeze package and run the migration

composer require laravel/breeze && php artisan migrate

Everything is still working at this point.

Then when I try to register a new user entering the adress localhost/register, I get the following error

lluminate??�\??�Database??�\??�QueryException
SQLSTATE[HY000] [2002] Connection refused

select count(*) as aggregate from `users` where `email` = my_new_user@test.com

Am I missing something in the .env or the docker-compose.yml ?

Thanks a lot

Source