Level 102
DB_HOST=name_of_the_mysql_service
Nov 14, 2022
14
Level 1
PDOException (2002) HELP SQLSTATE[HY000] [2002] Connection refused
good day Im running mysql in docker, but something went wrong, I don't know the main reason, I did search already but didn't find the answer yet. pls help me I'm new in docker thank you.
the error message,,
public function createConnection($dsn, array $config, array $options)
{
$username = Arr::get($config, 'username');
$password = Arr::get($config, 'password');
try {
$pdo = new PDO($dsn, $username, $password, $options);
} catch (Exception $e) {
$pdo = $this->tryAgainIfCausedByLostConnection(
my .env file,,
DB_CONNECTION=mysql
DB_HOST=0.0.0.0
DB_PORT=3306
DB_DATABASE=eca01
DB_USERNAME=root
DB_PASSWORD=admin123
DB_PREFIX=tb_
Level 1
@Sinnbeck i tried it and this is the error, PDOException (2002) HELP SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
Level 102
@username1 Show docker-compose.yml
Level 1
version: '3.8'
networks: # Docker Network laraveldockerize:
services:
# Webserver Services
webserver:
image: httpd:latest
container_name: eca_apache
restart: unless-stopped
ports:
- "8080:80"
volumes:
- .:/var/www/html
depends_on:
- php
# - mysql
networks:
- laraveldockerize
# MySQL Services
# mysql:
# image: mysql:5.7
# container_name: eca_mysql
# restart: always
# # tty: true
# ports:
# - "33061:3306"
# environment:
# MYSQL_DATABASE: ${DB_DATABASE}
# # MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
# # MYSQL_PASSWORD: ${DB_PASSWORD}
# # MYSQL_USER: ${DB_USERNAME}
# # SERVICE_TAGS: dev
# # SERVICE_NAME: mysql
# # MYSQL_DATABASE: 'eca-server02'
# MYSQL_ALLOW_EMPTY_PASSWORD: 1
# MYSQL_PASSWORD: ""
# # volumes:
# # - ./dockerize/mysql/data:/var/lib/mysql
# networks:
# - laraveldockerize
# PHP Services
php:
build:
context: .
dockerfile: ./.docker/Dockerfile
container_name: eca_php
volumes:
- .:/var/www/html
ports:
- 9000:80
networks:
- laraveldockerize
# Composer Services
composer:
image: composer:latest
container_name: eca_composer
volumes:
- .:/var/www/html
working_dir: /var/www/html
depends_on:
- php
networks:
- laraveldockerize
# NPM Services
npm:
image: node:14.9
container_name: eca_npm
volumes:
- .:/var/www/html
working_dir: /var/www/html
entrypoint: ['npm']
# Artisan Services
artisan:
build:
context: .
dockerfile: ./.docker/Dockerfile
container_name: eca_artisan
volumes:
- .:/var/www/html
# depends_on:
# - mysql
working_dir: /var/www/html
entrypoint: ['php', '/var/www/html/artisan']
networks:
- laraveldockerize
Level 102
@username1 You removed the mysql container ?
Level 1
I commented mysql services, since pulled a new one from docker hub. and its container name is ecs-mysql
Level 102
@username1 You still need it to be in your docker-compose.yml to be able to use it in that project. You can point the image: to it
image: ecs-mysql
Add it back in and rebuild
Level 1
@Sinnbeck do i need to compose a new one? since i commented it. and that mysql that i commented still in my docker container but I'm not running it. only the mysql that i pulled in dockerhub.
Level 1
@Sinnbeck ah ok now i understand. thank you, i will rebuild it first.
Level 102
@username1 Stop the one you pulled in. Add it to that docker-compose.yml and rebuild. You might need to remove the old container if the data isnt compatible.
Level 1
@Sinnbeck ok thank you i will try that..
Level 1
i did what you told, but the error still the same.
Level 102
@username1 Check that the container is actually running. docker ps
Level 1
@Sinnbeck yes its running.
Please or to participate in this conversation.