Wordpress container throwing "Connection refused" errors when using non-standard MySQL port

[mpmumau]

I'm attempting to use a different port for my MySQL container in a docker-compose file I have set up to run with the Wordpress Docker image my docker-compose file looks like so:

version: '2'

services:
  db:
    image: mysql:latest
    volumes:
      - ./volumes/db:/var/lib/mysql
    restart: always
    ports:
      - "6951:3306"
    environment:
      MYSQL_ROOT_PASSWORD: wordpress
      MYSQL_DATABASE: wordpress
  wordpress:
    depends_on:
      - db
    image: wordpress
    working_dir: /var/www/html
    volumes:
      - ./app:/var/www/html/wp-content
      - ./volumes/uploads:/var/www/html/wp-content/uploads
      - ./scripts:/opt/scripts
    ports:
      - "6952:80"
    restart: always
    links:
      - db:mysql
    environment:
      WORDPRESS_DB_HOST: db:6951
      WORDPRESS_DB_NAME: wordpress
      WORDPRESS_DB_PASSWORD: wordpress
      ENV: local
    build:
      context: ./
      dockerfile: docker/wordpress/Dockerfile
volumes:
    db_data:
    legacy_files:

However, after I bring the containers up with the above config, I am unable to access the Wordpress application via a browser, and likewise the docker logs command for the container results in the following error:

Warning: mysqli::__construct(): (HY000/2002): Connection refused in Standard input code on line 22

MySQL Connection Error: (2002) Connection refused

It seems as if there is some additional environment variable, perhaps, that I need to set in order to use a non-standard MySQL port. Any information about this would be much appreciated.

[wglambert]

You'll want to add command: --default-authentication-plugin=mysql_native_password to mysql

And for modifying the port you might want to edit the mysql config; the Docker port remapping is for external connections and doesn't re-map ports between containers. So for any connections like [External] -> [Docker_host] -> [Container]; the External and Docker_host can use 6951, but the container will use 3306

If you have further questions you should ask the Docker Community Forums, the Docker Community Slack, or Stack Overflow. As these repositories are for issues with the image and not necessarily for questions of usability

[mpmumau]

That is exactly it; thanks so much for the help!

[swapnilnakate7]

That is exactly it; thanks so much for the help!

Hi I am facing the same problem as you were. could you please share the config for the same which resolved your issue? Following is my .yml which is causing the issue[MySQL Connection Error: (2002) php_network_getaddresses: getaddrinfo failed: Name or service not known]:

version: '3.3'

services:
db:
image: mysql:5.7
command: --default-authentication-plugin=mysql_native_password
volumes:
- db_data:/var/lib/mysql
restart: unless-stopped
environment:
MYSQL_ROOT_PASSWORD: somewordpress
MYSQL_DATABASE: wordpress
MYSQL_USER: wordpress
MYSQL_PASSWORD: wordpress

wordpress:
depends_on:
- db
image: wordpress:latest
ports:
- "8080:443"
restart: unless-stopped
environment:
WORDPRESS_DB_HOST: db:3306
WORDPRESS_DB_USER: wordpress
WORDPRESS_DB_PASSWORD: wordpress
WORDPRESS_DB_NAME: wordpress
volumes:
db_data: {}