mysqli_real_connect() : MySQL server has gone away

Question

我正在尝试从 Windows 10 64 位启动 xampp v3.2.4。我收到图像 error page while connecting mysql 中显示的错误

xampp log

1. 我从sql数据文件夹中删除了ibdata1、ib_logfile1、ib_logfile0并重新启动了xampp和系统

2. 更改了配置文件中的值

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

下面是我的日志文件

2019-09-27 10:05:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2019-09-27 10:05:28 0 [Note] InnoDB: Uses event mutexes

2019-09-27 10:05:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-09-27 10:05:28 0 [Note] InnoDB: Number of pools: 1

2019-09-27 10:05:28 0 [Note] InnoDB: Using SSE2 crc32 instructions

2019-09-27 10:05:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2019-09-27 10:05:28 0 [Note] InnoDB: Completed initialization of buffer pool

2019-09-27 10:05:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2019-09-27 10:05:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-09-27 10:05:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2019-09-27 10:05:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

2019-09-27 10:05:28 0 [Note] InnoDB: Waiting for purge to start

2019-09-27 10:05:28 0 [Note] InnoDB: 10.3.16 started; log sequence number 1604020; transaction id 9

2019-09-27 10:05:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2019-09-27 10:05:28 0 [Note] InnoDB: Buffer pool(s) load completed at 190927 10:05:28

2019-09-27 10:05:28 0 [Note] Plugin 'FEEDBACK' is disabled.

2019-09-27 10:05:28 0 [Note] Server socket created on IP: '::'.

请帮我解决这个问题

Answer 1

更改my.ini中的数据包大小max_allowed_pa​​cket = 64M即可解决问题

my.ini 文件位于 Xampp controlpanel > mysql > config > my.ini