不能连接到MySQL服务器(2006错误)


Can't connect to MySQL server (2006 Error)

我最近正在使用MySQL,但是发生了一件非常奇怪的事情。

我希望我能在这里找到解决方案!

<?php
$servername = "theServername";
$username = "theUsername";
$password = "thePassword";
$dbname = "theDatabaseName";
$conn = new mysqli($servername,$username,$password,$dbname);
if ($conn->connect_error) {
    die("MySQL connection failed: " . $conn->connect_error);
    echo "Couldn't connect.";
} 
else {
  echo "It connected.";
}
?>

它一直显示我

警告:mysqli::mysqli(): MySQL server has gone away inC:'Users'Star1'PhpstormProjects'something'database.php on line 10

警告:mysqli::mysqli(): Error while reading greeting packet。PID=7520 ' users ' star1 'PhpstormProjects'something'database.php on10号线

警告:mysqli::mysqli(): (HY000/2006): MySQL server has gone away inC:'Users'Star1'PhpstormProjects'something'database.php,第10行MySQL连接失败:MySQL server has gone away

,第10行是$dbname,是new mysqli类的最后一个参数。

注意:我把正确的信息放在字符串引号内,但这只是一个例子。

Try This

$con = mysqli_connect($servername, $username, $password,$dbname);

Mysql Server has gone away

$servername = "theServername";
$username = "theUsername";
$password = "thePassword";
$dbname = "theDatabaseName";
@$conn = new mysqli($servername, $username, $password, $dbname);
if (mysqli_connect_errno()) {
   die("MySQL connection failed: " . mysqli_connect_error());
   echo "Couldn't connect.";
} else {
   echo "It connected.";
}