Issue MySQL php_network_getaddresses: getaddrinfo failed: Name or service not known

[JohnWorks]

Hello community,

I have a problem connecting to my database. Remote Access is enabled (Go to Tools & Settings > Database Servers > Settings > click Local MySQL Settings: Select the Allow local MySQL server to accept external connections checkbox, and then click OK Link).

Database name, user and password are correct. Hostname is: localhost:3306

PHP: 7.4.30 FPM-Anwendung (Apache) mysqli is enabled

The data is in a subdomain, which is registered as a separate application.

    private $servername = "localhost:3306";
    private $username = "user";
    private $password = "pw";
    private $dbname = "dbname";

    private $conn;

    function __construct() {

        $this->conn = new mysqli($this->servername, $this->username, $this->password, $this->dbname);

        if ($this->conn->connect_error) {

            die("Connection failed: " . $this->conn->connect_error);

        }

        $this->conn->set_charset("utf8");

    }

Displayed error in the browser:

Connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known

Displayed error in the log:

AH01071: Got error 'PHP message: PHP Warning: mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/vhosts/domain/subdomain.domain.de/db.php on line 30PHP message: PHP Warning: mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/vhosts/domain/subdomain.domain.de/db.php on line 30', referer: https://subdomain.domain.de/login.php

Plesk Obsidian 18.0.45 (Ubuntu) on IONOS

 

[IgorG]

private $servername = "localhost:3306";

What about

private $servername = "127.0.0.1:3306";

 

[JohnWorks]

What about

private $servername = "127.0.0.1:3306";

The same error...

bind-address:127.0.0.1

how-to-enable-remote-access-to-mysql-server-in-plesk