douyi7283 2018-04-06 17:39
浏览 1050

mysqli_connect():( HY000 / 2002):连接被拒绝(远程MySQL)

I have one shared Cpanel Hosting and one My own server with cpanel hosting. I am trying to connect from shared cpanel hosting to my own server for get data from my own server. I have added my shared cpanel hosting IP to my server cpanel in remote MySQL section but I am getting above error. I have also added that IP from WHM but not success. I have checked that port 3306 also open. I do not know whats issue. I have tried below connection type but same error always.

$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();
  }

I have also tried below code

 $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();
      }

But I am getting error like this

Failed to connect to MySQL: Connection refused 

and in error log like this

mysqli_connect(): (HY000/2002): Connection refused in

Let me know whats wrong with it and how can I solve it. Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 C#调用python代码(python带有库)
    • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
    • ¥15 活动选择题。最多可以参加几个项目?
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题
    • ¥20 云服务Linux系统TCP-MSS值修改?
    • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
    • ¥20 怎么在stm32门禁成品上增加查询记录功能
    • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面