我有一个共享的Cpanel托管和一个我自己的服务器与cpanel托管 . 我正在尝试从共享的cpanel托管连接到我自己的服务器,以从我自己的服务器获取数据 . 我已将我的共享cpanel托管IP添加到我的远程MySQL部分中的服务器cpanel但我收到了上述错误 . 我还从WHM添加了IP,但没有成功 . 我已检查端口3306是否也打开 . 我不知道什么问题 . 我试过下面的连接类型,但总是有同样的错误 .
$SERVER_NAME = "195.201.XXX.XXX";
$USER_NAME = "MyUserName";
$PASSWORD = "MyPass";
$DATABASE = "Mydb";
$conn = mysqli_connect($SERVER_NAME, $USER_NAME, $PASSWORD, $DATABASE,"3306");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
我也试过下面的代码
$SERVER_NAME = "195.201.XXX.XXX";
$USER_NAME = "MyUserName";
$PASSWORD = "MyPass";
$DATABASE = "Mydb";
$conn = mysqli_connect($SERVER_NAME, $USER_NAME, $PASSWORD, $DATABASE);
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
但我得到这样的错误
Failed to connect to MySQL: Connection refused
并在这样的错误日志中
mysqli_connect(): (HY000/2002): Connection refused in
让我知道它有什么问题,我该如何解决它 . 谢谢