警告:mysqli_connect():未知的 MySQL 服务器主机

我在连接到 mysql 服务器时遇到了一些问题.我可以使用 linux 终端连接，所以我知道我的主机、端口、用户和密码有效.但是，我无法使用 PHP 进行连接.

PHP 版本: 5.2.17

服务器版本: 5.5.27-log MySQL Community Server (GPL)

这是一个测试代码示例:

给出以下警告:

<块引用>

警告:mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'host.com:5306' (1) in/.../test.php on line 3

连接失败:未知 MySQL 服务器主机 'host.com:5306' (1)

有什么想法可以做什么吗?

解决方案

端口号必须是一个单独的参数:

$link = mysqli_connect('host', 'user', 'pass', 'db', 5306);

I have some trouble connecting to a mysql server. I can connect using the linux terminal, so I know that my host, port, user, and password works. I cannot, however, connect using PHP.

PHP Version: 5.2.17

Server version: 5.5.27-log MySQL Community Server (GPL)

Here is a test code example:

<?php

$link = mysqli_connect('host.com:5306', 'user', 'pass', 'db');

/* check connection */

if (mysqli_connect_errno()) {
    printf("Connect failed: %s
", mysqli_connect_error());
    exit();
}

if (!mysqli_query($link, "SET a=1")) {
    printf("Errormessage: %s
", mysqli_error($link));
}

/* close connection */
mysqli_close($link);    

?>

Gives the following warning:

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'host.com:5306' (1) in /.../test.php on line 3

Connect failed: Unknown MySQL server host 'host.com:5306' (1)

Any ideas on what to do?

解决方案

The port number must be a separate argument:

$link = mysqli_connect('host', 'user', 'pass', 'db', 5306);