Mysql Connection Error: (2002) Connection refused

[javiergermanjesus]

I can see the wordpress panel in "//localhost:8080", but i can't pass the login.

I have this errors:

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.3. Set the 'ServerName' directive globally to suppress this message
wordpress_1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.3. Set the 'ServerName' directive globally to suppress this message
wordpress_1  | [Sun May 24 14:30:54.630523 2020] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.3.18 configured -- resuming normal operations
wordpress_1  | [Sun May 24 14:30:54.630580 2020] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND

when i try "sudo docker-compose -f stack.yml up"

I'm using Fedora 30, but in windows i save a similar problem.
"Access denied for exampleuser@172.18.0.3....."

I haver installed docker, then i run:

"$docker pull wordpress
$docker run --name some-wordpress -p 8080:80 -d wordpress
$sudo docker-compose -f stack.yml up"

The "stack.yml" is:

version: '3.1'

services:

  wordpress:
    image: wordpress
    restart: always
    ports:
      - 8080
    environment:
      WORDPRESS_DB_HOST: db
      WORDPRESS_DB_USER: exampleuser
      WORDPRESS_DB_PASSWORD: examplepass
      WORDPRESS_DB_NAME: exampledb
    volumes:
      - wordpress:/var/www/html

  db:
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_DATABASE: exampledb
      MYSQL_USER: exampleuser
      MYSQL_PASSWORD: examplepass
      MYSQL_RANDOM_ROOT_PASSWORD: '1'
    volumes:
      - db:/var/lib/mysql

volumes:
  wordpress:
  db:

[wglambert]

Your ports: is just exposing 8080, but apache is listening on 80,

https://github.com/docker-library/docs/tree/master/wordpress#-via-docker-stack-deploy-or-docker-compose

Using that example I can connect to the container's address

$ mysql -h172.20.0.3 -uexampleuser -pexamplepass
Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MySQL connection id is 26
Server version: 5.7.30 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]>

You could also try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum

[javiergermanjesus]

Thanks for your answer.

I'm a noob in Docker.

I have installed Wordpress with Docker (SO: Win 7)

I can't login using docker-compose and the yml file. I had this problem: "MySQL Connection Error".

So, i run the following commands:

$docker run -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=wordpress --name wordpressdb -v "$PWD/database":/var/lib/mysql -d mariadb:latest

$docker pull wordpress

$docker run -e WORDPRESS_DB_PASSWORD=password --name wordpress --link wordpressdb:mysql -p 8083:80 -v "$PWD/html":/var/www/html -d wordpress

I could enter to the initial WordPress setup page at http://192.168.99.100:8083/wp-admin/install.php;
and it work it!

I could work with my site, but then i rebooted the PC and now, i can't access to my site.

The container's status were "Exited". So, i restarted the containers, but wordpress appared as if i have never used it.

[sajozsattila]

I think the problem here: your DB is not ready before the WordPress is starting. Manual workaround:

docker-compose up db # wait until it is ready
docker-compose up wordpress 

[mariuscucuruz]

@javiergermanjesus you should implement dependency on your wordpress service:

links: db
and
depends_on: db

This will build the services in the correct order and ensure availability of SQL database when WordPress is created.
Hope this works.

[tianon]

Closing since this appears to be a usability/installation issue (not really something we can fix in the image).

In the future (or for further help), these sorts of questions/requests would be more appropriately posted to a dedicated support forum such as the Docker Community Forums, the Docker Community Slack, or Stack Overflow.