php cannot connect to mysql in docker-compose

Question

Here is my docker-compose

version: '2'

services:
  nginx:
    image: nginx:1.11.8-alpine
    ports:
      - "8081:80"
    volumes:
      - ./code:/usr/share/nginx/html
      - ./html:/myapp
      - ./site.conf:/etc/nginx/conf.d/site.conf
      - ./default.conf:/etc/nginx/conf.d/default.conf
      - ./error.log:/var/log/nginx/error.log
      - ./nginx.conf:/etc/nginx/nginx.conf
    links:
      - phpfpm
  phpfpm:
    image: php7-fpm:latest
    ports:
      - "9000:9000"
    volumes:
      -  ./code:/usr/share/nginx/html
    links:
      - db_mysql
  db_mysql:
    image: mysql:5.7.17
    volumes:
      - db_data:/var/lib/mysql
    # restart: no
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: wp2017
      MYSQL_USER: wp
      MYSQL_PASSWORD: wp2017
volumes:
  db_data:

Here is how I build my own php7-fpm:lastest

FROM php:7.1-fpm-alpine
RUN docker-php-ext-install mysqli

I cannot connect to mysql container

$serverName = 'localhost';
$userName = 'wp';
$password = 'wp2017';
$dbName = 'wp2017';

$link = mysqli_connect($serverName, $userName, $password, $dbName);

if (mysqli_connect_errno()) {
   printf("Connect failed: %s\n", mysqli_connect_error());
  exit();
}

I always get error: " Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/share/nginx/html/db.php on line 8 Connect failed: No such file or directory"

Where I run command sudo netstat -tulpn | grep :3306

I get this tcp6 0 0 :::3306 :::* LISTEN 15362/docker-proxy

Please help !

I also cannot connect. I installed a mysql server in local ( Ubuntu 14.04 ) but I already stop it. Seems it is reason ? — anhduc.bkhn
– anhduc.bkhn, Commented Jan 16, 2017 at 8:30
are you sure mysqli is installed properly? have a look at the phpinfo if it is running — Pingbeat
– Pingbeat, Commented Jan 16, 2017 at 8:32
@Pingbeat it is working for me now. Here is what I fixed $serverName = 'db_mysql:3306'; // not localhost, 127.0.0.1... — anhduc.bkhn
– anhduc.bkhn, Commented Jan 16, 2017 at 9:50

anhduc.bkhn · Accepted Answer · 2017-01-16 10:03:10Z

23

Change PHP script

$serverName = 'db_mysql';

It will work.

answered Jan 16, 2017 at 10:03

anhduc.bkhn

7533 gold badges11 silver badges21 bronze badges

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

2 Comments

marcogmonteiro Over a year ago

Thanks this helped, but why is that? Because the name in the docker file is mysql? So if I wanted to connect to localhost I should've name it localhost?

rashidkhan Over a year ago

You can give it a name like container_name: yourname and then use it instead of a localhost and it should work.

Collectives™ on Stack Overflow

php cannot connect to mysql in docker-compose

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related