Sami Sami - 1 year ago 109
PHP Question

mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it

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

Things i tried:-

  • checked firewall

  • restarted my PC and Apache server

  • restarted MYSQL

  • checked my code

  • Tried everything i know and found on internet

here's my code:-


$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';



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

Here's the firewall picture:-
enter image description here

lastly XAMMP is running here's the proof

enter image description here

Answer Source

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';