# Error establishing a database connection Error Kubernates wordpress & mysql

**URL:** <https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407>\
**Category:** General Discussions\
**Created:** [April 5, 2021, 3:37pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407 "2021-04-05T15:37:44Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 5, 2021, 3:37pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/1 "2021-04-05T15:37:44Z")

</div>

**mysql-deployment.yaml**

```
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql-deployment
  labels:
    app: mysql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
      - name: mysql
        image: mysql:5.7
        ports:
        - containerPort: 80
        env:
        - name: MYSQL_ROOT_PASSWORD
          value: DEVOPS1
        - name: MYSQL_USER
          value: wpuser
        - name: MYSQL_PASSWORD
          value: DEVOPS12345
        - name: MYSQL_DATABASE
          value: wpdb

```

mysql-service.yaml

```
    apiVersion: v1
    kind: Service
    metadata:
      name: mysql-service
    spec:
      selector:
        app: mysql
      ports:
        - protocol: TCP
          port: 3306
          targetPort: 3306

```

**wordpress-deployment.yaml**

```
                apiVersion: apps/v1
                kind: Deployment
                metadata:
                  name: wordpress-deployment
                  labels:
                    app: wordpress
                spec:
                  replicas: 3
                  selector:
                    matchLabels:
                      app: wordpress
                  template:
                    metadata:
                      labels:
                        app: wordpress
                    spec:
                      containers:
                      - name: wordpress
                        image: wordpress
                        ports:
                        - containerPort: 80
                        env:
                        - name: WORDPRESS_DB_HOST
                          value: mysql-service
                        - name: WORDPRESS_DB_USER
                          value: wpuser
                        - name: WORDPRESS_DB_PASSWORD
                          value: DEVOPS12345
                        - name: WORDPRESS_DB_NAME
                          value: wpdb
                        - name: WORDPRESS_DEBUG
                          value: "1"

```

**wordpress-service.yaml**

```
 apiVersion: v1
    kind: Service
    metadata:
      name: wordpress-service
    spec:
      type: NodePort
      selector:
        app: wordpress
      ports:
        - protocol: TCP
          port: 80
          targetPort: 80

```

**Please note : I used valid mysql credintials. (username,passwords) I double checked.**

Result

 ![error_db](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/2/21e5a817a1edb0a34866dadd6376fb0150b43fbf.png)

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 5, 2021, 8:12pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/2 "2021-04-05T20:12:20Z")

</div>

Hey @Sameera_Wijerathna I just took a peak at the config, and the service name in the `WORDPRESS_DB_HOST` is using an `_` instead of a `-`. I did a test with that corrected WP came up without the warning.

```auto
env:
  - name: WORDPRESS_DB_HOST
    value: mysql-service

```

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 6, 2021, 12:15am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/3 "2021-04-06T00:15:44Z")

</div>

@macintoshprime I modified. it . but same error has been showed me

 ![y1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/6/6fc5065da86d979dcfc53c151224799dfad715a5.png)

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 6, 2021, 11:47am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/4 "2021-04-06T11:47:59Z")

</div>

Can you run `kubectl get services` to see what is listed? Also is there any useful information being displayed in the logs (`kubectl logs -l app=wordpress`)?

Here’s the deployment YAML I used and a screenshot showing what I get after applying it.

```auto
apiVersion: apps/v1
kind: Deployment
metadata:
  name: wordpress-deployment
  labels:
    app: wordpress
spec:
  replicas: 3
  selector:
    matchLabels:
      app: wordpress
  template:
    metadata:
      labels:
        app: wordpress
    spec:
      containers:
      - name: wordpress
        image: wordpress
        ports:
        - containerPort: 80
        env:
          - name: WORDPRESS_DB_HOST
            value: mysql-service
          - name: WORDPRESS_DB_USER
            value: wpuser
          - name: WORDPRESS_DB_PASSWORD
            value: DEVOPS12345
          - name: WORDPRESS_DB_NAME
            value: wpdb
          - name: WORDPRESS_DEBUG
            value: “1”
---
apiVersion: v1
kind: Service
metadata:
  name: wordpress-service
spec:
  type: NodePort
  selector:
    app: wordpress
  ports:
    - protocol: TCP
      port: 80
      targetPort: 80

```

 ![Screen Shot 2021-04-06 at 07.44.59](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/f/fe4312801a0ff73f412e3ea26fb107d52b07eea5.png)

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 6, 2021, 12:08pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/5 "2021-04-06T12:08:45Z")

</div>

Thanks @macintoshprime . Please note , i m using AWS environment. here are the logs and others

Here is the online link, you can check it  
[http://13.250.30.67:32067/](http://13.250.30.67:32067/)

**Service Lists**

 ![services_list](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/f/fa1a54992c986b74af2428ed5e50cd0bb6dbeeb5.png)

**Wordpress logs**

```
root@ip-172-31-34-220:~/wordpress# kubectl logs -l app=wordpress
WordPress not found in /var/www/html - copying now...
Complete! WordPress has been successfully copied to /var/www/html
No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_DB_HOST WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_SERVICE_PORT WORDPRESS_SERVICE_PORT_80_TCP WORDPRESS_SERVICE_PORT_80_TCP_ADDR WORDPRESS_SERVICE_PORT_80_TCP_PORT WORDPRESS_SERVICE_PORT_80_TCP_PROTO WORDPRESS_SERVICE_SERVICE_HOST WORDPRESS_SERVICE_SERVICE_PORT)
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.2.14. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.2.14. Set the 'ServerName' directive globally to suppress this message
[Tue Apr 06 11:28:23.823529 2021] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.4.16 configured -- resuming normal operations
[Tue Apr 06 11:28:23.824749 2021] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
10.244.2.1 - - [06/Apr/2021:11:29:15 +0000] "-" 408 0 "-" "-"
WordPress not found in /var/www/html - copying now...
Complete! WordPress has been successfully copied to /var/www/html
No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_DB_HOST WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_SERVICE_PORT WORDPRESS_SERVICE_PORT_80_TCP WORDPRESS_SERVICE_PORT_80_TCP_ADDR WORDPRESS_SERVICE_PORT_80_TCP_PORT WORDPRESS_SERVICE_PORT_80_TCP_PROTO WORDPRESS_SERVICE_SERVICE_HOST WORDPRESS_SERVICE_SERVICE_PORT)
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.1.15. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.1.15. Set the 'ServerName' directive globally to suppress this message
[Tue Apr 06 11:28:27.341294 2021] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.4.16 configured -- resuming normal operations
[Tue Apr 06 11:28:27.341490 2021] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
WordPress not found in /var/www/html - copying now...
Complete! WordPress has been successfully copied to /var/www/html
No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_DB_HOST WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_SERVICE_PORT WORDPRESS_SERVICE_PORT_80_TCP WORDPRESS_SERVICE_PORT_80_TCP_ADDR WORDPRESS_SERVICE_PORT_80_TCP_PORT WORDPRESS_SERVICE_PORT_80_TCP_PROTO WORDPRESS_SERVICE_SERVICE_HOST WORDPRESS_SERVICE_SERVICE_PORT)
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.2.13. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 10.244.2.13. Set the 'ServerName' directive globally to suppress this message
[Tue Apr 06 11:28:20.244677 2021] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.4.16 configured -- resuming normal operations
[Tue Apr 06 11:28:20.244862 2021] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
10.244.2.1 - - [06/Apr/2021:11:28:23 +0000] "GET / HTTP/1.1" 500 2834 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
10.244.2.1 - - [06/Apr/2021:11:28:43 +0000] "GET /favicon.ico HTTP/1.1" 500 2834 "http://54.254.159.162:32067/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36"
```

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 10, 2021, 4:30pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/6 "2021-04-10T16:30:54Z")

</div>

Please help me

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 11, 2021, 4:00pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/7 "2021-04-11T16:00:32Z")

</div>

Hey Sameera,

Been thinking about this and just haven’t had a chance to get back to you. Sorry for the delay. Is the mysql pod throwing any errors or miss behaving in anyway?

Have you used any other service to see if you can connect to the `mysql-service` endpoint? [Here’s](https://kubernetes.io/docs/tasks/administer-cluster/dns-debugging-resolution/) a guide for checking DNS resolution in K8s. Would you be using network policies by any chance? I’m assuming everything is in the same namespace.

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 14, 2021, 11:07am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/8 "2021-04-14T11:07:05Z")

</div>

Please help me to resolve this . I m novice person to this . I found the issue. i cannot see AVAILABILITY status in DEPLOYMENTS. check this screenshot . then i run `kubectl describe all` command

Here is the result

 ![p1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/7/77ed5a903b2a3be452f526cf47068945e1f72303.png)

 ![f2](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/5/55f6b66fbbddf01515b555ee5b355ac15f8d199f.png)

Here are the all YAML files

**mysql-deployment.yaml**

```auto
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql-deployment
  labels:
    app: mysql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
      - name: mysql
        image: mysql:5.7
        ports:
        - containerPort: 80
        env:
        - name: MYSQL_ROOT_PASSWORD
          value: DEVOPS1
        - name: MYSQL_USER
          value: wpuser
        - name: MYSQL_PASSWORD
          value: DEVOPS12345
        - name: MYSQL_DATABASE
          value: wpdb

```

**mysql-service.yaml**

```auto
apiVersion: v1
kind: Service
metadata:
  name: mysql-service
spec:
  selector:
    app: mysql
  ports:
    - protocol: TCP
      port: 3306
      targetPort: 3306

```

**wordpress-deployment.yaml**

```auto
apiVersion: apps/v1
kind: Deployment
metadata:
  name: wordpress-deployment
  labels:
    app: wordpress
spec:
  replicas: 3
  selector:
    matchLabels:
      app: wordpress
  template:
    metadata:
      labels:
        app: wordpress
    spec:
      containers:
      - name: wordpress
        image: wordpress
        ports:
        - containerPort: 80
        env:
        - name: WORDPRESS_DB_HOST
          value: mysql-service
        - name: WORDPRESS_DB_USER
          value: wpuser
        - name: WORDPRESS_DB_PASSWORD
          value: wpdb

```

**wp-service.yaml**

```auto
apiVersion: v1
kind: Service
metadata:
  name: wordpress-service
spec:
  type: NodePort
  selector:
    app: wordpress
  ports:
    - protocol: TCP
      port: 80
      targetPort: 80

```

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 14, 2021, 11:36am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/9 "2021-04-14T11:36:18Z")

</div>

For the flannel network issue are you using EKS to provision your cluster or is it from EC2 instances with `kubeadm` or other tool?

If you have access to the nodes you might want to check to see what errors the `kubelet` and `kube-proxy` logs are showing. Reference → [Troubleshoot Clusters | Kubernetes](https://kubernetes.io/docs/tasks/debug-application-cluster/debug-cluster/#worker-nodes)

It also looks like some other users bumped into a similar issue and the solution was tracked in [this github](https://github.com/kubernetes/kubernetes/issues/70202) issue

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 14, 2021, 1:30pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/10 "2021-04-14T13:30:27Z")

</div>

Thanks @macintoshprime , I fixed it. now i got DB Connectivity error .

 ![db_error_1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/f/f8ad81cadc7e4eab8fe10a93bda8bdcbcc6b6913.png)

 ![kubectl_get_all](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/6/63d9d6aabe545cee5faca4bbb0dbd1068567c227.png)

**AWS Firewall**

 ![aws_firewall](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/5/551117176b2ae3e1d786d7f16c51d81679353e64.png)

**mysql-deployment.yaml**

```auto
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql-deployment
  labels:
    app: mysql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
      - name: mysql
        image: mysql:5.7
        ports:
        - containerPort: 80
        env:
        - name: MYSQL_ROOT_PASSWORD
          value: DEVOPS1
        - name: MYSQL_USER
          value: wpuser
        - name: MYSQL_PASSWORD
          value: DEVOPS12345
        - name: MYSQL_DATABASE
          value: wpdb

```

**mysql-service.yaml**

```auto
apiVersion: v1
kind: Service
metadata:
  name: mysql-service
spec:
  selector:
    app: mysql
  ports:
    - protocol: TCP
      port: 3306
      targetPort: 3306

```

**wordpress-deployment.yaml**

```auto
apiVersion: apps/v1
kind: Deployment
metadata:
  name: wordpress-deployment
  labels:
    app: wordpress
spec:
  replicas: 3
  selector:
    matchLabels:
      app: wordpress
  template:
    metadata:
      labels:
        app: wordpress
    spec:
      containers:
      - name: wordpress
        image: wordpress
        ports:
        - containerPort: 80
        env:
        - name: WORDPRESS_DB_HOST
          value: mysql-service
        - name: WORDPRESS_DB_USER
          value: wpuser
        - name: WORDPRESS_DB_PASSWORD
          value: wpdb

```

**wp-service.yaml**

```auto
apiVersion: v1
kind: Service
metadata:
  name: wordpress-service
spec:
  type: NodePort
  selector:
    app: wordpress
  ports:
    - protocol: TCP
      port: 80
      targetPort: 80

```

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 14, 2021, 1:33pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/11 "2021-04-14T13:33:59Z")

</div>

New errors = Progress 🙂 What do the wordpress logs say?

Try switching the `WORDPRESS_DB_PASSWORD` to `DEVOPS12345` .

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 14, 2021, 1:43pm UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/12 "2021-04-14T13:43:14Z")

</div>

@macintoshprime , Done. No luck

[http://18.140.61.142:30617/](http://18.140.61.142:30617/)  
[http://13.229.248.221:30617/](http://13.229.248.221:30617/)

 ![dd1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/5/5112bc47d4aab1a723d3dece2ac71935bd150d7c.png)

 ![debug_mode](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/9/901dd0023173ffa90406fed76c53455bf2aecfbd.png)

Also i modified my code like this . it also error

 ![ii1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/6/636b1f7b88a4e841c6b44c6abb91fc67dc713cbd.png)

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 15, 2021, 1:15am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/13 "2021-04-15T01:15:33Z")

</div>

last night I modified my files, I posed it to stackoverflow.

Please if there is any genius. Help me. I need to complete my Assignment ASAP ☹

> <https://stackoverflow.com/questions/67100931/aws-kubernetes-cluster-wordpress-error-establishing-a-database-connection>

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 15, 2021, 3:06am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/14 "2021-04-15T03:06:30Z")

</div>

Hey Sameera. Took another look and I was able to get things up and running but not in an AWS cluster (I don’t have access).

I put the working yaml in a code share so you could take a look [here](https://codeshare.io/ax9NnM). Based the changes off of the example from two post ago, only had to change the DB\_HOST and DB\_PASSWORD vars to get it working.

If that’s still giving you issues it might be something on the EKS side that’s giving some issues. Did you apply any network policies that might be interfering with communication (`kubectl get networkpolicies`)?

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 15, 2021, 3:29am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/15 "2021-04-15T03:29:20Z")

</div>

![ty1](https://us1.discourse-cdn.com/flex016/uploads/kubernetes/original/2X/2/25cc0ed11812850c4e5f54e9082404d65b371764.png)

---

<div class="post-metadata">

**Author:** ![Sameera\_Wijerathna](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sameera_wijerathna/32/7272_2.png) [@Sameera\_Wijerathna](https://discuss.kubernetes.io/u/Sameera_Wijerathna)\
**Post date:** [April 15, 2021, 3:40am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/16 "2021-04-15T03:40:36Z")

</div>

> [@macintoshprime](#):
>
> EKS

@macintoshprime This is not EKS related thing . i m trying to build up Kubernetes + docker + wordpress+mysql hosting by manually. simply says this is on premise cluster

---

<div class="post-metadata">

**Author:** ![macintoshprime](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/macintoshprime/32/7121_2.png) [@macintoshprime](https://discuss.kubernetes.io/u/macintoshprime)\
**Post date:** [April 15, 2021, 11:38am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/17 "2021-04-15T11:38:34Z")

</div>

Sadly I don’t have much relevant AWS experience. If the provided YAML doesn’t work then it might be something in the configuration of the cluster.

You might want to check the [required ports](https://kubernetes.io/docs/setup/production-environment/tools/kubeadm/install-kubeadm/#control-plane-node-s) to see if they are open, checking the `kubelet` and `kube-proxy` logs on the hosts should help with that.

Were you able to test the DNS to see if you could access the service from another pod? That would help isolate the issue to either being in the deployment or a cluster issue.

What tool did you use to provision the cluster, kops, kubeadm?

---

<div class="post-metadata">

**Author:** ![Hadhami\_riahi](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/hadhami_riahi/32/10308_2.png) [@Hadhami\_riahi](https://discuss.kubernetes.io/u/Hadhami_riahi)\
**Post date:** [June 20, 2022, 9:55am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/18 "2022-06-20T09:55:17Z")

</div>

Hey, did you find a solution i’m facing same problem here

---

<div class="post-metadata">

**Author:** ![Victoria\_Kelz](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/victoria_kelz/32/11772_2.png) [@Victoria\_Kelz](https://discuss.kubernetes.io/u/Victoria_Kelz)\
**Post date:** [February 5, 2023, 9:46am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/19 "2023-02-05T09:46:45Z")

</div>

I found this very helpful.  
Also used this [php - Warning: mysqli\_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) - Stack Overflow](https://stackoverflow.com/a/45127448)

---

<div class="post-metadata">

**Author:** ![Sujitha\_Penumuru](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.kubernetes.io/sujitha_penumuru/32/12818_2.png) [@Sujitha\_Penumuru](https://discuss.kubernetes.io/u/Sujitha_Penumuru)\
**Post date:** [July 3, 2023, 11:15am UTC](https://discuss.kubernetes.io/t/error-establishing-a-database-connection-error-kubernates-wordpress-mysql/15407/20 "2023-07-03T11:15:38Z")

</div>

hi Sameera\_Wijerathna, is this issue resolved? i am also facing the same problem