Mysql服务器已经消失了。 [英] Mysql server has gone away.

问题描述

Wile连接到MySql我收到错误 MySql服务器已经消失$ db = mysqli_connect（localhost：9080，root，XXXX）;



这是我的代码。

Wile connecting to MySql I am getting error "MySql server has gone away" on line "$db = mysqli_connect("localhost:9080","root","XXXX");"

Here is my code.

<?php
	ini_set('mysql.connect_timeout', 300);
	ini_set('default_socket_timeout', 300);
	
   define('DB_SERVER', 'localhost:9080');
   define('DB_USERNAME', 'root');
   define('DB_PASSWORD', 'XXXX');
   define('DB_DATABASE', 'api');
   
   //$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD);
   $db = mysqli_connect("localhost:9080","root","XXXX");
   
   // Check connection
	if (!$db) 
	{
		die("Connection failed: " . mysqli_connect_error());
	}
	
	$select_db = mysqli_select_db($db, DB_DATABASE);
	if(!$select_db)
	{
		die("Database selection failed: " . mysqli_error($db));
	}
	
	echo "Connected successfully";
?>

我有什么试过：



已添加

What I have tried:

Have added

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);

同时更新 max_allowed_Packet 至16 M.

然后重启所有服务。



错误屏幕截图： Imgur：互联网上最棒的图片 [ ^ ]

Also updated max_allowed_Packet to 16 M.
Then Restart all Services.

Error Screensshot: Imgur: The most awesome images on the Internet[^]

推荐答案

db = mysqli_connect（localhost：9080，root，XXXX）;



这是我的代码。

db = mysqli_connect("localhost:9080","root","XXXX");"

Here is my code.

<?php
	ini_set('mysql.connect_timeout', 300);
	ini_set('default_socket_timeout', 300);
	
   define('DB_SERVER', 'localhost:9080');
   define('DB_USERNAME', 'root');
   define('DB_PASSWORD', 'XXXX');
   define('DB_DATABASE', 'api');
   
   //

db = mysqli_connect（DB_SERVER ，DB_USERNAME，DB_PASSWORD）;

db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD);

db = mysqli_connect（ localhost：9080， root， XXXX）;

// 检查连接
if （！

db = mysqli_connect("localhost:9080","root","XXXX"); // Check connection if (!

这篇关于Mysql服务器已经消失了。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！