Can not connect mysql with laravel (docker)

Question

I'm very new to laravel and docker and trying to connect mysql to php container(laravel). I thought set right my docker-compose.yml and env file in laravel project.

Also, I can connect to mysql db inside the container.

Here is a error when I did php artisan migrate :

SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = myapp and table_name = migrations and table_type = 'BASE TABLE')

Can anyone know what happened?

docker-compose.yml

version: '3'

services:
  php:
    container_name: php
    build: ./docker/php
    volumes:
    - ./myapp/:/var/www


  nginx:
    image: nginx:latest
    container_name: nginx
    ports:
    - 80:80
    volumes:
    - ./myapp/:/var/www
    - ./docker/nginx/default.conf:/etc/nginx/conf.d/default.conf
    depends_on:
    - php

  db:
    image: mysql:8.0
    container_name: db
    environment:
      MYSQL_ROOT_PASSWORD: root1234
      MYSQL_DATABASE: myapp
      MYSQL_USER: docker
      MYSQL_PASSWORD: docker
      TZ: 'Asia/Tokyo'
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    ports:
    - 3306:3306

env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=myapp
DB_USERNAME=docker
DB_PASSWORD=docker

try using mysql:5.7 image (ie version 5.7 of mysql)

aryanveer
– aryanveer

2020-07-16 06:20:56 +00:00
Commented Jul 16, 2020 at 6:20 — aryanveer
– aryanveer, Commented Jul 16, 2020 at 6:20

via · Accepted Answer · 2020-07-26 12:05:30Z

8

finally this problem is solved. I changed .env DB_HOST=127.0.0.1 to DB_HOST=db then it's work!!

" DB_HOST= service name of mysql container on docker-compose.yml "

this time my mysql container name is db, so needed to DB_HOST to be db.

answered Jul 26, 2020 at 12:05

via

5032 gold badges8 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

flik Over a year ago

If I have another docker-compose with MySQL and PHPMyAdmin. Is it connect with this lamp environment. If yes then how ? #knkn @knkn

Kurt Friars · Accepted Answer · 2020-07-16 06:26:16Z

1

You are running mysql 8, there are considerations for the authentication mechanism. Try adding the following to your mysql container's command:

--default-authentication-plugin=mysql_native_password

MySQL version 8.0.4 has changed the default authentication mechanism from mysql_native_password to caching_sha2_password. The issue is that most clients have not implemented the ability to authenticate via this mechanism yet. In the case of Laravel, this is dependent upon PHP, and PHP only began supporting this in v7.4.

I personally have not tried to configure this in one of my projects yet, and am unsure if Laravel supports this "out of the box" yet.

edited Jul 16, 2020 at 6:26

answered Jul 16, 2020 at 6:11

Kurt Friars

3,7742 gold badges18 silver badges29 bronze badges

2 Comments

via Over a year ago

Thank you for your advice! I changed authentication mechanism. and showing up another error. SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = myapp and table_name = migrations and table_type = 'BASE TABLE'

Kurt Friars Over a year ago

You still need to create the database. PHP artisan migrate:fresh, will also work I believe.

Collectives™ on Stack Overflow

Can not connect mysql with laravel (docker)

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related