如何连接数据库（未知主机，没有ip）

Question

I have a database hosted by one.com with these settings:

PhpMyAdmin: https://dbadmin.one.com

Host: axelerate.be.mysql

Database: axelerate_be

Username: axelerate_be

Password: *****

I want to make connection with this database by using a php file runned by the LXTerminal of the raspberry pi. When i try to make connection i get this error (host unknown):

Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Host is onbekend. in C:\xampp\htdocs\twitter\index.php on line 3

Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Host is onbekend. in C:\xampp\htdocs\twitter\index.php on line 3 Failed to connect to MySQL: php_network_getaddresses: getaddrinfo failed: Host is onbekend.

This is my code:

<?php
    // Create connection
    $con=mysqli_connect("axelerate.be.mysql","axelerate_be","*******","axelerate_be");

    // Check connection
    if (mysqli_connect_errno()) {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }else{
        echo "it works!";
    }
?>

My question:

How can i make this connection work without edditing any config files? (so if there is something to do, I want only to write in the php file)

Thanks!

Answer 1

The .mysql based hosts are internal hosts within the one.com network that resolves to the server that hosts your database. These hosts are not meant for connections outside of one.com hosting, and probably doesn't accept connections from the world if they're even available on a public IP.