警告:mysqli_connect():未知的MySQL服务器主机 [英] Warning: mysqli_connect(): Unknown MySQL server host
问题描述
我在连接到mysql服务器时遇到了一些麻烦.我可以使用linux终端进行连接,所以我知道我的主机,端口,用户和密码都可以使用.但是,我无法使用PHP进行连接.
PHP版本: 5.2.17
服务器版本::5.5.27-log MySQL Community Server(GPL)
这是一个测试代码示例:
<?php
$link = mysqli_connect('host.com:5306', 'user', 'pass', 'db');
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if (!mysqli_query($link, "SET a=1")) {
printf("Errormessage: %s\n", mysqli_error($link));
}
/* close connection */
mysqli_close($link);
?>
给出以下警告:
警告:mysqli_connect()[function.mysqli-connect]:(HY000/2005):第3行/.../test.php中未知的MySQL服务器主机'host.com:5306'(1)>
连接失败:未知的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\n", mysqli_connect_error());
exit();
}
if (!mysqli_query($link, "SET a=1")) {
printf("Errormessage: %s\n", 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);
这篇关于警告:mysqli_connect():未知的MySQL服务器主机的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!