Question

本地开发环境实例测试数据库连接总是报错$con=mysqli_connect("127.0.0.1","root","root","test");

Warning: mysqli_connect(): Unexpected server respose while doing caching_sha2 auth: 109 in F:\Apache24\htdocs\index.php on line 14
Warning: mysqli_connect(): MySQL server has gone away in F:\Apache24\htdocs\index.php on line 14
Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in F:\Apache24\htdocs\index.php on line 14
连接错误: MySQL server has gone away

Answer 1

• 数据库连接设置看下：数据库地址、数据库账号、数据库密码；

• 建议的测试php代码如下：

  <?php

  $con = mysql_connect("$ip","$shujuku","$mima");

  if (!$con)

  {

  die('不能连接数据库: ' . mysql_error());

  }

  else

  {

  print "连接数据库成功 OK!";

  }

  ?>

$ip  数据库ip地址

$shujuku 数据库用户名

$mima     数据库密码。

Answer 2

重新修改紫色对应的色彩软件上C、M、Y三种原色的比例数字即可。