How to enable php's mysql extensions in docker container?

Question

i have the following docker-compose.yml

web:
  image: nginx:1.17.1-alpine
  ports:
    - "80:80"
  volumes:
    - ./code:/code
    - ./site.conf:/etc/nginx/conf.d/site.conf
  links:
    - php

php:
  build: .
  volumes:
    - ./code:/code
  links:
    - mysql

mysql:
  image: yobasystems/alpine-mariadb:latest
  ports:
    - "3306:3306"
  volumes:
    - ./mysql:/var/lib/mysql
environment: 
    - MYSQL_ROOT_PASSWORD=password

and following dockerfile

FROM php:7.1.0-fpm-alpine

RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

In this setup , php's mysql extensions or docker mysql extensions never get installed. i cannot access mysql from php container. adminer.php complains saying "None of the supported PHP extensions (MySQLi, MySQL, PDO_MySQL) are available."

How do we fix this problem ?

score 39 · Answer 1 · edited Jul 24 '19 at 12:59

39

Adding the following to dockerfile fixed the issue.

RUN docker-php-ext-install mysqli pdo pdo_mysql && docker-php-ext-enable pdo_mysql

edited Jul 24 '19 at 12:59

Jay Blanchard

33,530
16
73
113

answered Jul 24 '19 at 12:57

Danushka Gunawardena

819
1
7
15

in the original post , its bit different, pdo parts are missing in it. – Danushka Gunawardena Jul 24 '19 at 12:58
1

Thank you for this! I think the `mysqli` bit is not really required. It's an extension apart from PDO. – gyohza Feb 08 '21 at 02:02

How to enable php's mysql extensions in docker container?

1 Answers1

Linked