Docker Connecting PHP container to MySQL

Question

I have two containers, a apache-php container, and a mysql db container. I am trying to get my php script to query my sql database. I am however receiving the following errors;

Fatal error: Uncaught PDOException: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known

AND

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory

when toggling the host address, i think i am missing something fundamental to docker and this is driving my crazy.

My docker compose looks like;

version: '2'

services:

    applications:
      image: tianon/true
      volumes:
        - /var/www/test:/var/www/html

    mysql_store:
      image: tianon/true
      volumes:
        - /var/www/test/mysql:/var/lib/mysql

    apache2:
      build:
        context: ./apache2
      volumes_from:
        - applications
      ports:
        - "80:80"
      depends_on:
       - mysql
      links:
        - mysql
    mysql:
      build:
        context: ./mysql
        volumes_from:
          - mysql_store
      environment:
        - MYSQL_DATABASE=testapp
        - MYSQL_USER=johnm
        - MYSQL_PASSWORD=johnm
        - MYSQL_ROOT_PASSWORD=secret
      volumes:
        - ./mysql/save:/var/lib/mysql
      ports:
        - "3306:3306"

my mysql dockerfile looks like

FROM mysql:8

MAINTAINER Mahmoud Zalt <[email protected]>

#####################################
# Set Timezone
#####################################

ARG TZ=UTC
ENV TZ ${TZ}
RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN chown -R mysql:root /var/lib/mysql/

ADD my.cnf /etc/mysql/conf.d/my.cnf

CMD ["mysqld"]

EXPOSE 3306

my apache dockerfile looks like;

FROM php:7.0-apache
#COPY ./src/ /var/www/html/i
#RUN apt-get update && add-apt-repository ppa:ondrej/php && apt-get update && apt-get install php7.0-mysql
RUN apt-get update && apt-get install -y \
    && docker-php-ext-install pdo pdo_mysql \
    && docker-php-ext-enable pdo pdo_mysql

and finally my index.php looks like

<?php
    $db = new PDO('mysql:host=localhost;port=3306;dbname=testapp', 'root', 'secret');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

    var_dump($db->query('SELECT * from users'));

For my database host i have tried "db", "localhost" and "127.0.0.1".

Any help on this will be greatly appreciated!

Your Common Sense · Accepted Answer · 2025-04-01 05:34:22Z

16

What you need to use as a host name in the DSN is the service name: mysql:

 $db = new PDO('mysql:host=mysql;port=3306;dbname=testapp', 'root', 'secret');

Because you named as so the MySQL compose service:

    mysql:
      build:
        context: ./mysql
...

edited Apr 1 at 5:34

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

answered Jul 9, 2017 at 0:27

Robert

37.6k8 gold badges97 silver badges101 bronze badges

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

3 Comments

John Mack Over a year ago

Ah cool, as i believe it, docker will create dns alias for everything put under links, so essentially mysql will link to 0.0.0.0. Thank you very much for the help

Simone Bonelli Over a year ago

@Robert helpful answer

Simone Bonelli Over a year ago

to connect mysql cli client, from host system external to the container $ mysql -h localhost -P 3306 --protocol=tcp -u root -p

Collectives™ on Stack Overflow

Docker Connecting PHP container to MySQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related