[Docker]: Connecting PHPMyAdmin to MySQL doesnt work

Question

I'm trying to connect a PHPMyAdmin-Container to a MySQL-Container to view the databases.

I have started the MySQL container via $ docker run --name databaseContainer -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql

and the PHPMyAdmin-Container via $ docker run --name myadmin -d --link databaseContainer:mysql -p 8080:8080 phpmyadmin/phpmyadmin

When trying to login on PHPMyAdmin, I get: mysqli_real_connect(): php_network_getaddresses: getaddrinfo failed: Name does not resolve

and

mysqli_real_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name does not resolve

By the way, I have also started a wordpress container and also linked it to mysql, there it works...

Eugen Mayer · Accepted Answer · 2019-11-15T18:58:43.763

37

Instead of starting them one by one, use docker-compose.

Create a docker-compose.yml file

version: '2'
services:
  db:
    image: mysql
    environment:
      MYSQL_ROOT_PASSWORD: my-secret-pw
    ports:
      # just if you also want to access it directly from you host
      # node neede for phpmyadmin
      - "3306:3306"
  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    depends_on:
      - db
    ports:
      - "8080:8080"

Then start it using docker-compose up in the same folder your docker-compose.yml file is located. Access PHPmyadmin using the browser and use 'db' as the hostname of your database, since that is the name of the service in the docker-compose.yml file and therefore can be resolved using dockers internal DNS service to the actual ip of the docker-container. All the links are setup for you automatically.

That's much simpler - docker run overcomplicates things and is not practical for those things - never.

Hint: if docker-compose is not installed on your machine, install it using this official docs https://docs.docker.com/compose/install/ (out of scope)

edited Nov 15 '19 at 18:58

answered Aug 20 '16 at 16:05

Eugen Mayer

8,942
4
33
57

Thanks, it works! I also found out, that entering the environment variables (DB-Host, User, PW) is an option, just the linking doesn't work... – Pascal Aug 21 '16 at 09:57
you can enter all those ENV variables in docker compose also, but i guess thats clear – Eugen Mayer Aug 21 '16 at 10:57
I didn't know that you could use 'db' as the hostname. Thanks for that! – Jake88 Jun 19 '17 at 21:29
you should add a space after MYSQL_ROOT_PASSWORD: – Oussama Bouthouri Nov 15 '19 at 10:27

JL M · Answer 2 · 2016-11-15T13:11:02.200

21

The configuration file of phpmyadmin/phpmyadmin (/www/config.inc.php) say by default the host name of database server if 'db' :

$hosts = array('db');

So if your database name container is not 'db', you should add the environment variable PMA_HOST= (or PMA_HOSTS if multi db servers) with the right name (databaseContainer in your case)

edited Nov 15 '16 at 13:11

answered Nov 15 '16 at 11:39

JL M

1,378
1
10
14

1

when I run `docker run --name myadmin -d --link mysql_db_server:db -p 8080:80 phpmyadmin/phpmyadmin` it would work, but not with docker-compose for some reason, without the env var. Your suggestion for the env var should be in all the docs. Docker docs gloss over too many details! – gdbj Apr 30 '17 at 16:56

score 4 · Answer 3 · edited May 16 '18 at 11:33

docker run --name db -e MYSQL_ROOT_PASSWORD=mypass -d mysql:5.7

docker run -p 80:80 --link db:mysql phpmyadmin/phpmyadmin

Try executing the above command it will work, as phpmyadmin may have hardcoded the in their implementation that the mysql server conatiner name to be db.

If you still want to give your db server a unique name, add PMA_HOST environment variable:

docker run --name myadmin -d --link mysqlserver:mysql -p 8080:80 -e PMA_HOST=mysqlserver phpmyadmin/phpmyadmin

mysqlserver is the name give to your mysql db server.

score 3 · Answer 4 · answered Sep 06 '18 at 15:14

GIVEN you started the MySQL container as:

$ docker run --name databaseContainer -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql

THEN you should actually create phpmyadmin as follows:

$ docker run --name myadmin -d --link mysql:db -p 8080:8080 phpmyadmin/phpmyadmin

It is actually advisable that you include a network. So you would have:

$ docker run --name databaseContainer --network myDockerNetwork -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql

AND

$ docker run --name myadmin -d --link mysql:db --network myDockerNetwork -p 8080:8080 phpmyadmin/phpmyadmin

Make sure your network is created first:

$ docker network create myDockerNetwork

score 3 · Answer 5 · answered Jan 02 '19 at 12:23

3

In my case, I was using MySQL 8.0 and it turned out that mysql has introduced a new password identification which is not supported by phpmyadmin. See this answer.

answered Jan 02 '19 at 12:23

vivanov

1,422
3
21
29

score 2 · Answer 6 · answered Oct 04 '18 at 16:03

I've had the same error installing docker using laradock, then running docker-compose up. Out of the box, default config throws this error when you attempt to log into phpMyAdmin (using current images as of Oct 2018). The error was not present using docker run.

For docker-compose.yml (version 3), one cause is services running on different networks by default. For anyone else having this issue, here is a config that works for mysql and phpmyadmin.

Inside "docker-compose.yml" file, under "services":

### db ###################################################
    db:
      image: mysql:5.7
      container_name: db
      environment:
        - MYSQL_ROOT_PASSWORD=mypass
      networks:
       - backend

### MySQL ################################################
    mysql:
      build:
        context: ./mysql
        args:
          - MYSQL_VERSION=${MYSQL_VERSION}
      environment:
        - MYSQL_DATABASE=${MYSQL_DATABASE}
        - MYSQL_USER=${MYSQL_USER}
        - MYSQL_PASSWORD=${MYSQL_PASSWORD}
        - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
        - TZ=${WORKSPACE_TIMEZONE}
      volumes:
        - ${DATA_PATH_HOST}/mysql:/var/lib/mysql
        - ${MYSQL_ENTRYPOINT_INITDB}:/docker-entrypoint-initdb.d
      ports:
        - "${MYSQL_PORT}:3306"
      networks:
        - backend

## phpMyAdmin ###########################################
    phpmyadmin:
      build: ./phpmyadmin
      environment:
        - PMA_ARBITRARY=1
        - PMA_HOST=db
        - MYSQL_USER=${PMA_USER}
        - MYSQL_PASSWORD=${PMA_PASSWORD}
        - MYSQL_ROOT_PASSWORD=${PMA_ROOT_PASSWORD}
      ports:
        - "${PMA_PORT}:80"
      depends_on:
        - db
        - mysql
      networks:
        - frontend
        - backend

Edit the ".env" file as follows:

### MYSQL #################################################

MYSQL_VERSION=5.7
MYSQL_DATABASE=db
MYSQL_USER=root
MYSQL_PASSWORD=mypass
MYSQL_PORT=3306
MYSQL_ROOT_PASSWORD=mypass
MYSQL_ENTRYPOINT_INITDB=./mysql/docker-entrypoint-initdb.d

### PHP MY ADMIN ##########################################

# Accepted values: mariadb - mysql

PMA_DB_ENGINE=mysql

# Credentials/Port:

PMA_USER=default
PMA_PASSWORD=secret
PMA_ROOT_PASSWORD=secret
PMA_PORT=8080

Add the following line to the "/etc/hosts" file:

127.0.0.1   localhost

Assuming you're also using nginx, and that config is elsewhere in your "docker-compose.yml", you can build and start these services with:

docker-compose up -d mysql nginx db phpmyadmin

Then navigate to localhost:8080 in your browser and login with username "root" and password "mypass" (leave server field blank).

[Docker]: Connecting PHPMyAdmin to MySQL doesnt work

6 Answers6

Linked

Related