我有一个共享的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

让我知道它有什么问题,我该如何解决它 . 谢谢