docker mysql connection via php

Question

I have the following settings in docker-compose.yml

mysql:
  image: mysql:latest
  ports:
    - "3306"
  volumes:
    - /var/lib/mysql
  environment:
    MYSQL_ROOT_PASSWORD: secret
    MYSQL_DATABASE: project
    MYSQL_USER: project
    MYSQL_PASSWORD: project

In my index.php, I want to connect to my database container, however, I'm not sure what to type in host=localhost,

the following code doesn't work

<?php
$db = new PDO('mysql:host=localhost;dbname=project;charset=utf8mb4', 'project', 'secret');

It says

Fatal error: Uncaught PDOException: could not find driver in /code/index.php:2 Stack trace: #0 /code/index.php(2): PDO->__construct('mysql:host=loca...', 'project', 'secret') #1 {main} thrown in /code/index.php on line 2

Thanks

Change localhost by your VM IP. here

t10508hn
– t10508hn

2016-07-28 08:06:34 +00:00
Commented Jul 28, 2016 at 8:06 — t10508hn
– t10508hn, Commented Jul 28, 2016 at 8:06

Camilo Silva · Accepted Answer · 2016-07-27 23:38:12Z

1

Your error message indicates that Mysql driver is unavailable.

In Ubuntu/Debian you check for the package with:

dpkg --get-selections | grep php5-mysql

Install the php5-mysql package if you do not have it.

In Ubuntu/Debian you can use:

sudo apt-get install php5-mysql

After you add that module be sure to map mysql port to any port in your host, for example

mysql:
 image: mysql:latest
 ports:
  - "3306:3306"
...

After that, you can use mysql:host=localhost:3306

answered Jul 27, 2016 at 23:38

Camilo Silva

8,7334 gold badges46 silver badges63 bronze badges

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

1 Comment

ldg Over a year ago

You probably want to use an IP address instead of localhost or the mysql driver may try to use the socket connection. Alternatively, you can add a PHP container to your docker-compose and reference the service name (e.g., mysql) as the host value.

Collectives™ on Stack Overflow

docker mysql connection via php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related