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

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 ?

Jay Blanchard · Accepted Answer · 2019-07-24 12:59:44Z

69

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, 2019 at 12:59

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered Jul 24, 2019 at 12:57

Danushka Gunawardena

1,2791 gold badge10 silver badges17 bronze badges

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

3 Comments

Danushka Gunawardena Over a year ago

in the original post , its bit different, pdo parts are missing in it.

gyohza Over a year ago

Thank you for this! I think the mysqli bit is not really required. It's an extension apart from PDO.

RobMac Dec 30, 2024 at 0:33

Yes, mysqli and pdo are separate. In my case I needed it.

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related