mysqlierror php,将PHP连接到MYSQL时发生mysqli_error（）

I know that there are tons of questions related to this but I can't find the problem with my codes.

Here are my PHP codes:

//set the connection variables

$hostname = "localhost";

$username = "root";

$password = "password";

$database = "fyp";

$filename = "C:/scripts/nea.csv";

//connect to mysql database

$myConnection = mysqli_connect($hostname, $username, $password, $database)

or die("Error " . mysqli_error($myConnection));

// open the csv file

$fp = fopen($filename,"r");

//parse the csv file row by row

while(($row = fgetcsv($fp,"500",",")) != FALSE)

{

//insert csv data into mysql table

$sql = "INSERT INTO neaweather (ValidTime, Date, Time, Lat, Lon, AreaName) VALUES ( '".mysql_escape_string($row[0])."','".mysql_escape_string($row[1])."','".mysql_escape_string($row[2])."','".mysql_escape_string($row[3])."','".mysql_escape_string($row[4])."','".mysql_escape_string($row[5])."')";

$query = mysqli_query($myConnection,$sql);

if($query){

echo "row inserted\n";

}

else{

echo die(mysql_error());

}

}

fclose($fp);

//close the db connection

mysqli_close($myConnection);

?>

The codes worked perfectly fine when I ran it yesterday.

Here are the details to MYSQL table :

Here are the error when I ran the codes :

C:\scripts>php neaweather.php

PHP Warning: mysqli_connect(): (HY000/2002): No connection could be made

because the target machine actively refused it.in C:\scripts\neaweather.php

on line 10

Warning: mysqli_connect(): (HY000/2002): No connection could be made because

the target machine actively refused it. in C:\scripts\neaweather.php on line

10

PHP Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given

in C:\scripts\neaweather.php on line 10

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in

C:\scripts\neaweather.php on line 10

Error

This is line 10 of the code :

//connect to mysql database

$myConnection = mysqli_connect($hostname, $username, $password, $database)

or die("Error " . mysqli_error($myConnection));

解决方案

Your screenshot says your mysql server is running on port 3307. By default 3306 is used.

You need to replace this :

$myConnection = mysqli_connect($hostname, $username, $password, $database) or die("Error " . mysqli_error($myConnection));

With this:

$myConnection = mysqli_connect($hostname, $username, $password, $database, 3307) or die("Error " . mysqli_error($myConnection));