错误:MySQL意外关闭.在xampp-control上 [英] Error: MySQL shutdown unexpectedly. on xampp-control
本文介绍了错误:MySQL意外关闭.在xampp-control上的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在运行Windows 10，当我尝试从xampp-control启动我的MySQL时，出现一条错误消息，提示错误:MySQL意外关闭.
I'm running windows 10 and when I try to start my MySQL from xampp-control i'm getting an error saying Error: MySQL shutdown unexpectedly.
我尝试了几种解决方案，例如从taskmanager中杀死 mysqld 进程并删除 ibdata1 文件，但仍然遇到相同的问题...
I tried several solution like killing the mysqld process from the taskmanager and deleting ibdata1 file but still getting the same issue...
以下是我的错误日志，请注意仅包括了本月的记录
following is my error log, please note only the this month's records have been included
2020-07-06 11:05:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:05:10 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:05:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:05:10 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:05:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:05:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:05:10 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:05:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:05:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:05:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:05:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:05:11 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:05:11 0 [Note] InnoDB: 10.4.11 started; log sequence number 47064; transaction id 9
2020-07-06 11:05:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:05:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:05:11 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:05:11
2020-07-06 11:05:11 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:05:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:05:57 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:05:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:05:57 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:05:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:05:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:05:57 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:05:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:05:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:05:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:05:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:05:57 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:05:57 0 [Note] InnoDB: 10.4.11 started; log sequence number 47073; transaction id 9
2020-07-06 11:05:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:05:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:05:57 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:05:57
2020-07-06 11:05:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:06:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:06:07 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:06:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:06:07 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:06:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:06:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:06:07 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:06:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:06:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:06:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:06:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:06:07 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:06:08 0 [Note] InnoDB: 10.4.11 started; log sequence number 47082; transaction id 9
2020-07-06 11:06:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:06:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:06:08 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:06:08
2020-07-06 11:06:08 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:09:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:09:08 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:09:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:09:08 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:09:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:09:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:09:08 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:09:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:09:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:09:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:09:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:09:08 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:09:08 0 [Note] InnoDB: 10.4.11 started; log sequence number 47091; transaction id 9
2020-07-06 11:09:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:09:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:09:08 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:09:08
2020-07-06 11:09:08 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:14:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:14:58 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:14:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:14:58 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:14:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:14:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:14:58 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:14:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:14:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:14:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:14:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:14:59 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:14:59 0 [Note] InnoDB: 10.4.11 started; log sequence number 47116; transaction id 9
2020-07-06 11:14:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:14:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:14:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:14:59
2020-07-06 11:14:59 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:15:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:15:45 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:15:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:15:45 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:15:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:15:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:15:45 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:15:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:15:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:15:45 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:15:45 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:15:45 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:15:45 0 [Note] InnoDB: 10.4.11 started; log sequence number 47125; transaction id 9
2020-07-06 11:15:45 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:15:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:15:45 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:15:45
2020-07-06 11:15:45 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:22:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:22:01 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:22:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:22:01 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:22:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:22:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:22:01 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:22:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:22:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:22:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:22:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:22:02 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:22:02 0 [Note] InnoDB: 10.4.11 started; log sequence number 47134; transaction id 9
2020-07-06 11:22:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:22:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:22:02 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:22:02
2020-07-06 11:22:02 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:22:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:22:28 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:22:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:22:28 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:22:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:22:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:22:28 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:22:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:22:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:22:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:22:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:22:28 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:22:28 0 [Note] InnoDB: 10.4.11 started; log sequence number 47143; transaction id 9
2020-07-06 11:22:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:22:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:22:28 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:22:28
2020-07-06 11:22:28 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:23:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:23:39 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:23:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:23:39 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:23:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:23:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:23:39 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:23:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:23:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:23:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:23:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:23:40 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:23:40 0 [Note] InnoDB: 10.4.11 started; log sequence number 47152; transaction id 9
2020-07-06 11:23:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:23:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:23:40 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:23:40
2020-07-06 11:23:41 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:24:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:24:03 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:24:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:24:03 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:24:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:24:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:24:03 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:24:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:24:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:24:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:24:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:24:03 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:24:03 0 [Note] InnoDB: 10.4.11 started; log sequence number 47161; transaction id 9
2020-07-06 11:24:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:24:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:24:03 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:24:03
2020-07-06 11:24:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:24:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:24:34 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:24:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:24:34 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:24:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:24:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:24:34 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:24:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:24:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:24:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:24:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:24:35 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:24:35 0 [Note] InnoDB: 10.4.11 started; log sequence number 47170; transaction id 9
2020-07-06 11:24:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:24:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:24:35 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:24:35
2020-07-06 11:24:35 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:24:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:24:51 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:24:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:24:51 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:24:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:24:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:24:51 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:24:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:24:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:24:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:24:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:24:51 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:24:51 0 [Note] InnoDB: 10.4.11 started; log sequence number 47179; transaction id 9
2020-07-06 11:24:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:24:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:24:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:24:51
2020-07-06 11:24:51 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:27:02 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-07-06 11:27:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:27:02 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:27:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:27:02 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:27:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:27:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:27:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:27:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-07-06 11:27:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
2020-07-06 11:27:02 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2020-07-06 11:27:02 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2020-07-06 11:27:02 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2020-07-06 11:27:02 0 [Note] InnoDB: New log files created, LSN=11452
2020-07-06 11:27:02 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-07-06 11:27:03 0 [Note] InnoDB: Doublewrite buffer created
2020-07-06 11:27:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:27:03 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-07-06 11:27:03 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-07-06 11:27:03 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-07-06 11:27:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:27:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:27:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:27:03 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:27:03 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-07-06 11:27:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:27:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:50:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:50:52 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:50:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:50:52 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:50:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:50:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:50:52 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:50:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:50:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:50:52 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:50:52 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:50:52 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:50:52 0 [Note] InnoDB: 10.4.11 started; log sequence number 47055; transaction id 9
2020-07-06 11:50:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:50:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:50:52 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:50:52
2020-07-06 11:50:52 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:51:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:51:52 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:51:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:51:52 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:51:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:51:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:51:52 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:51:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:51:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:51:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:51:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:51:53 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:51:53 0 [Note] InnoDB: 10.4.11 started; log sequence number 47064; transaction id 9
2020-07-06 11:51:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:51:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:51:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:51:53
2020-07-06 11:51:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:52:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:52:48 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:52:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:52:48 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:52:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:52:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:52:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:52:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:52:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:52:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:52:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:52:48 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 11:52:48 0 [Note] InnoDB: 10.4.11 started; log sequence number 47073; transaction id 9
2020-07-06 11:52:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:52:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:52:48 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:52:48
2020-07-06 11:52:48 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-07-06 11:56:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 11:56:45 0 [Note] InnoDB: Uses event mutexes
2020-07-06 11:56:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 11:56:45 0 [Note] InnoDB: Number of pools: 1
2020-07-06 11:56:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 11:56:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 11:56:45 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 11:56:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 11:56:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 11:56:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 11:56:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 11:56:46 0 [Note] InnoDB: 10.4.11 started; log sequence number 47082; transaction id 9
2020-07-06 11:56:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-06 11:56:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 11:56:46 0 [Note] InnoDB: Buffer pool(s) load completed at 200706 11:56:46
2020-07-06 11:56:46 0 [Note] Server socket created on IP: '::'.
推荐答案
由于端口阻塞而出现的问题
Issue due to port blocking
MySql通常在端口3306上启动服务器，其他一些程序(例如Skype)也可以使用它.确保更改端口号.
MySql generally starts server on port 3306 which can be used by some other programs like Skype. Ensure you change the port number.
首先通过启动任务管理器→服务→使用端口3306检查程序并终止(通常与操作系统无关)，确保没有程序正在使用端口3306.如果完成了上述检查，则只需打开XAMPP控制面板→MySql配置→my.ini→将端口3306替换为3307或3308(空闲端口).展开窗口→右上角的配置→服务和端口设置→MySql→主端口→3307(假定)→保存转到XAMPP文件夹(无论安装在哪里)→htdocs→php→php文件(配置类型)→将端口3306替换为3307→从控制面板启动服务器，并检查服务器是否工作正常.
Initially ensure that no program is using port 3306 by starting Task Manager → Services → Check program using port 3306 and terminate (generally it is not related to OS) If the above checking is done then simply open XAMPP Control Panel → MySql config → my.ini → replace port 3306 to 3307 or 3308 (free port). Expand window → Config at right top → Service and port settings → MySql → Main Port → 3307 (assume) → Save Go to XAMPP folder wherever it is installed → htdocs → php → php file (configuration type) → replace port 3306 to 3307 → start the server from control panel and check if it works perfectly fine or not.
这篇关于错误:MySQL意外关闭.在xampp-control上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
