如何修复读取问候包时出现的错误？

Question

我正在尝试连接NetBeans中的服务器。我写的代码如下：

<?php
echo "wlecome";
echo "<br>";

$conn=mysqli_connect("mydomain.com:2082", "phpmyadmin_user", "password","database_name");
                     
echo $conn;
?>

运行此代码会返回以下错误：

wlecome

Warning: mysqli_connect(): MySQL server has gone away in C:\xampp\htdocs\myprojet\index.php on line 10

Warning: mysqli_connect(): Error while reading greeting packet. PID=1092 in C:\xampp\htdocs\myprojet\index.php on line 10

Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in C:\xampp\htdocs\myprojet\index.php on line 10

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\myprojet\index.php on line 10

Answer 1

出于安全原因，可以将MySQL配置为不接受外部连接。说出域名全称，表示您使用的是公网IP，因此是外部连接。如果MySQL与您的via服务器在同一个机器上运行，只需通过以下域名访问它：

localhost:2082

Answer 2

试着只使用不带端口的localhost，它对我很有效。