What is mysql connection error?

Question

MySQL

Good afternoon.
Mistake

SQLSTATE[HY000] [2002] Connection refused (SQL: select * from `users`)

mysql settings from .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=33062
DB_DATABASE=lv-eliseev
DB_USERNAME=root
DB_PASSWORD=root

mysql settings from docker-compose.yml

mysql:
    image: mysql:5.7
    restart: always
    environment:
      - "MYSQL_ROOT_PASSWORD=root"
    volumes:
      - "./docker/mysql:/var/lib/mysql"
    ports:
      - "33062:3306"

Containers start normally.

Connected to the database through workbench


Executed php artisan migrateand the tables were created.

docker-compose version 3.1

Thanks in advance.

Answer 1

DB_HOST=mysql
DB_PORT=3306

127.0.0.1 inside a container points to the container, not the host. Docker itself creates a network for your containers and they communicate through it, and not through the host.

I ran php artisan migrate and the tables were created.

Stop executing commands on the host - all work must be done in containers, otherwise there is no point in using them.