警告:mysqli_connect():MySQL服务器已经走了 [英] Warning: mysqli_connect(): MySQL server has gone away
本文介绍了警告:mysqli_connect():MySQL服务器已经走了的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我写了一个简单的php代码连接到mysql服务器如下
I wrote a simple php code to connect to the mysql server as below
<?php
$username = "root";
$password = "Kepwd";
$hostname = "localhost:81";
//connection to the database
$dbhandle = mysqli_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
?>
但会产生以下错误。我在google和stactoverflow中发现了一些关于这个问题的主题。但这些都不帮助我。
but this generates following errors. I found some topics regarding this issue in google and stactoverflow. but those aren't help me. please can anyone help me ?
( ! ) Warning: mysqli_connect(): MySQL server has gone away in C:\wamp\www\SSDConsultingNew\inc\test.php on line 8
Call Stack
# Time Memory Function Location
1 0.0014 240936 {main}( ) ..\test.php:0
2 0.0014 241528 mysqli_connect ( ) ..\test.php:8
( ! ) Warning: mysqli_connect(): Error while reading greeting packet. PID=10612 in C:\wamp\www\SSDConsultingNew\inc\test.php on line 8
Call Stack
# Time Memory Function Location
1 0.0014 240936 {main}( ) ..\test.php:0
2 0.0014 241528 mysqli_connect ( ) ..\test.php:8
( ! ) Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in C:\wamp\www\SSDConsultingNew\inc\test.php on line 8
Call Stack
# Time Memory Function Location
1 0.0014 240936 {main}( ) ..\test.php:0
2 0.0014 241528 mysqli_connect ( ) ..\test.php:8
Unable to connect to MySQL
推荐答案
错误在这里:
$hostname = "localhost:81";
您不是连接到MySQL,而是连接到Apache服务器。如果没有更改MySQL端口,只需使用
You are not connecting to MySQL, but to Apache server. If you didn't change MySQL port just use
$hostname = "localhost";
这篇关于警告:mysqli_connect():MySQL服务器已经走了的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文