Can't connect to database, even though I can connect to database!

[secoldPrivate]

My current setup is using wordpress with Kubernetes, and a google cloud SQL server.
The Cluster has a cloudproxy setup (which basically makes it 'virtually' seem like the database is available within the cluster.

I've got the environment variables set correctly but when the container starts it says:

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

MySQL Connection Error: (2002) Connection refused 

I know the hostname, password, and such are correct in the environment variables:

  WORDPRESS_DB_HOST: <hostname>
  WORDPRESS_DB_USER: <username>
  WORDPRESS_DB_PASSWORD: <password>

I know this because I can exec into the container, install a mysql client, and connect to the remote database USING those environment variables!

But for some reason with wordpress starts up it can't connect.
I'm unsure how to debug this.

[wglambert]

Are you using Kubernetes secrets?

[televators]

Hot dang, I've been scouring the intertubes for this same issue for a few days. Migrating from old Macbook to WSL2 and for some reason, everything works on Mac but on Ubuntu, I'm getting the "can't select database" error. Using the same .env setup all my sites use and am using the standard WP docker image with 5.5.1. Everything else seems fine except this.

[secoldPrivate]

So I've fixed this.

The issue is appears to be table prefixes.
The table prefix I had was:
"wp"
I got it to work by changing it to "wp_".

Odd as hell to give a Connection refused error but, as far as I know that solved it for me. Going to leave this open in-case there is a solution that makes more sense or someone can confirm/reproduce that having an incorrect table prefix causes a connection Refused error, because it seems ridiculous to me.

[secoldPrivate]

Are you using Kubernetes secrets?

ConfigMaps in this case actually, since then I've moved the pw into secrets.

[wglambert]

Cool, closing then since this seems resolved

If you have further questions you could try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum

[ardyfeb]

php suck