問題描述
我在連接到 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);
這篇關于警告:mysqli_connect():未知的 MySQL 服務器主機的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！