CODEWITHSUNDEEP
mysqldockerdocker-compose
DevWizard
DevWizard

Reputation: 697

mysql docker cannot connect from outside container

I've created a docker-compose file for PHP dev but I cannot connect to the DB with sequel pro neither from the APP.

version: '3'
services:

  #PHP Service
  app:
    build:
      context: .
      dockerfile: Dockerfile
    image: digitalocean.com/php
    container_name: app
    restart: unless-stopped
    tty: true
    environment:
      SERVICE_NAME: app
      SERVICE_TAGS: dev
    working_dir: /var/www
    volumes:
      - ./:/var/www
      - ./php/local.ini:/usr/local/etc/php/conf.d/local.ini
    networks:
      - app-network

  #Nginx Service
  webserver:
    image: nginx:alpine
    container_name: webserver
    restart: unless-stopped
    tty: true
    volumes:
      - ./:/var/www
      - ./nginx/conf.d/:/etc/nginx/conf.d/
    ports:
      - "80:80"
      - "443:443"
    networks:
      - app-network

  #MySQL Service
  db:
    image: mysql:latest
    container_name: db
    restart: unless-stopped
    tty: true
    ports:
      - "3306:3306"
    expose:
      # Opens port 3306 on the container
      - '3306'
    environment:
      MYSQL_DATABASE: laravel
      MYSQL_USER: laraveluser
      MYSQL_PASSWORD: root
      MYSQL_ROOT_PASSWORD: root
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
    volumes:
      - ./mysql/data:/var/lib/mysql
      - ./mysql/my.cnf:/etc/my.cnf
    networks:
      - app-network

#Docker Networks
networks:
  app-network:
    driver: bridge

everything works OK and no errors are displayed but when I'm trying to connect to the DB in any way it doesn't work docker-compose exec app PHP artisan migrate nor with sequel Pro, what's wrong with my config?

The only way to access the DB is with docker-compose exec db bash

here the full repo

Upvotes: 1

Views: 5262

Answers (2)

DevWizard
DevWizard

Reputation: 697

straight from the GitHub repo I have the answer, though I haven't tried yet as I think I'm going to stick with 5.7 for now.

You might need to add --default-auth=mysql_native_password to your command

Mysql:8 uses caching_sha2_password by default https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password

#454 (comment)

Upvotes: 1

Kapil Khandelwal
Kapil Khandelwal

Reputation: 1176

After digging into your code, I found that you need to update .env.example file

Replace DB_HOST=db on line 10.

You must have missed it, but it is already mentioned in the post that you had referred, under the heading "Step 8 — Modifying Environment Settings and Running the Containers".

Upvotes: 0

Related Questions