MySQL can't connect to 127.0.0.1

wav3front

Hi,

When I use 127.0.0.1 on the PHP app, I get:

Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /var/www/****************/dev.*****.com/wp-includes/class-wpdb.php on line 1987
Connection refused

Whereas when I use "localhost" it works.
The MySQL user is defined on 127.0.0.1 host.

bug?

Thanks
Alex

Adam

This is because PHP is containerised and has its own network namespace, 127.0.0.1 is loopback on the container not the host o/s. If you use localhost then PHP will use the unix domain socket file which is available to the PHP container.

wav3front

I understand. So the correct way to connect is via localhost.

Thank you
Alex