mysqli_connect到远程服务器 [英] mysqli_connect to remote server
问题描述
我正在尝试连接到远程服务器.我认为问题出在端口号,但是当我尝试报告错误时,我没有得到任何信息.
I'm trying to connect to a remote server. I think the problem is with the port number, but when I try error reporting, I'm not getting any information.
$db_host = 'MY.IP.ADD.RESS:3306';
$db_user = 'user';
$db_pass = 'password';
$db_database = 'database';
$link = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a NHT_DB connection');
if (!$link) {
die('Connect Error: ' . mysqli_connect_error());
}
else {
echo 'Success... ' . mysqli_get_host_info($link) . "\n";
}
首先,我不是100%确信这是正确的端口.如何找出设置为使用mysql的端口?
First, I'm not 100% confident that's the correct port. How do I find out what port mysql is set to use?
第二,mysqli_connect_error()
没有给我任何东西.没有数字,没有代码,什么都没有.测试页只会吐出Connect Error:
,而没有我可以查找的代码.
Second, mysqli_connect_error()
isn't giving me anything. No number, codes, nothing. The test page just spits back Connect Error:
with out as much as a code I can go look up.
推荐答案
解决方案是向mysqli_connect函数添加端口参数.
Solution was to add a port argument to the mysqli_connect function.
$db_host = 'MY.IP.ADD.RESS';
$db_user = 'user';
$db_pass = 'password';
$db_database = 'database';
$db_port = '3306';
$link = mysqli_connect($db_host,$db_user,$db_pass,$db_database,$db_port);
这篇关于mysqli_connect到远程服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!