mysqli_connect(): (HY000/2002): 由于目标机器主动拒绝,无法建立连接

时间:2023-03-07
本文介绍了mysqli_connect(): (HY000/2002): 由于目标机器主动拒绝,无法建立连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我知道有很多这样的问题,但我没有找到任何解决方案.

I know there are many questions like this, but i didn't find any solution in it.

我尝试过的事情:-

  • 检查防火墙

  • checked firewall

重新启动了我的电脑和 Apache 服务器

restarted my PC and Apache server

重启MYSQL

检查了我的代码

尝试了我在互联网上知道和找到的一切

Tried everything i know and found on internet

这是我的代码:-

<?php

$dbhost = 'localhost:3360';
$dbuser = 'root';
$dbpass = '';
$db     = 'test_db13';


$conn  = mysqli_connect($dbhost,$dbuser,'',$db);

if(! $conn){
  die('Could not connect connect: ') ;
}

echo 'Successfully Connected';


$sql = 'Connected Successfully';
  $retvalue = mysqli_query($sql);

  if(! $retvalue){
    die('Cannot connect to SQL: ');
  }

echo 'DataBase test_db13 has successfully created';

mysqli_close($conn);

 ?>

我确实设置了密码,但它仍然显示错误.

I did set the password, but it still is showing me the error.

这是防火墙图片:-

最后 XAMMP 正在运行,这是证明

lastly XAMMP is running here's the proof

推荐答案

如果你看看你的 XAMPP 控制面板,它清楚地说明 MySQL 服务器的端口是 3306 - 你提供了 3360.3306 是默认的,因此不需要指定.即便如此,mysqli_connect() 的第 5 个参数是端口,也就是应该指定的地方.

If you look at your XAMPP Control Panel, it's clearly stated that the port to the MySQL server is 3306 - you provided 3360. The 3306 is default, and thus doesn't need to be specified. Even so, the 5th parameter of mysqli_connect() is the port, which is where it should be specified.

您可以完全删除端口规范,因为您使用的是默认端口,使其成为

You could just remove the port specification altogether, as you're using the default port, making it

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db     = 'test_db13';

参考资料

  • mysqli_connect()
  • MySQL 标准连接

这篇关于mysqli_connect(): (HY000/2002): 由于目标机器主动拒绝,无法建立连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:new mysqli():如何拦截“无法连接"错误? 下一篇:bind_param 有什么作用?

相关文章