Arhn - архитектура программирования

Ошибка: неожиданное завершение работы MySQL. на xampp-контроле

Я использую Windows 10, и когда я пытаюсь запустить MySQL из xampp-control, я получаю сообщение об ошибке Error: MySQL shutdown unexpectedly.

Я пробовал несколько решений, таких как уничтожение процесса mysqld из диспетчера задач и удаление файла ibdata1, но все равно возникает та же проблема...

Ниже приведен мой журнал ошибок, обратите внимание, что включены только записи этого месяца.

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: '::'.

  • Может быть журнал ошибок. Пожалуйста, обратите внимание на это. Вы также можете опубликовать то же самое здесь, чтобы мы рассмотрели это. 06.07.2020
  • привет @ATULKUMARSINGH я обновил вопрос 06.07.2020
  • Вы уверены, что у вас нет другой службы mysql, использующей тот же порт? Кроме того, не могли бы вы заглянуть в журнал ошибок mysql, чтобы лучше понять проблему. 06.07.2020
  • да, я обновил свой вопрос 06.07.2020
  • Не могли бы вы проверить свой диспетчер задач и убедиться, что у вас уже есть запущенный экземпляр mysql, проверьте процесс с именем mysqld.exe? 06.07.2020
  • @ATULKUMARSINGH Я обновил вопрос, и да, я уже убил процесс mysqld 06.07.2020
  • Я не вижу никаких проблем, зарегистрированных в файле журнала. 06.07.2020
  • да, но продолжайте получать ошибку, и сервер не запускается 06.07.2020
  • Возможно, вы захотите сослаться на это один раз, похоже, проблема несколько похожа на вашу stackoverflow.com/questions/56767200/cant-run-xampp-mysql. 06.07.2020
  • да это сработало! 06.07.2020
  • Приятно чувствовать себя полезным. :) 06.07.2020

Ответы:


1

Проблема из-за блокировки порта

MySql обычно запускает сервер на порту 3306, который может использоваться некоторыми другими программами, такими как Skype. Убедитесь, что вы изменили номер порта.

Первоначально убедитесь, что никакая программа не использует порт 3306, запустив Диспетчер задач → Службы → Проверьте программу, используя порт 3306, и завершите работу (как правило, это не связано с ОС). Если вышеуказанная проверка выполнена, просто откройте Панель управления XAMPP → Конфигурация MySql → my. ini → заменить порт 3306 на 3307 или 3308 (свободный порт). Разверните окно → Конфигурация справа вверху → Настройки службы и порта → MySql → Основной порт → 3307 (предположим) → Сохранить. Перейдите в папку XAMPP, где бы она ни была установлена ​​→ htdocs → php → файл php (тип конфигурации) → замените порт 3306 на 3307 → запустите сервер из панели управления и проверьте, работает ли он нормально или нет.

06.07.2020
  • В данном случае это не проблема. 06.07.2020
  • Новые материалы

    Коллекции публикаций по глубокому обучению
    Последние пару месяцев я создавал коллекции последних академических публикаций по различным подполям глубокого обучения в моем блоге https://amundtveit.com - эта публикация дает обзор 25..

    Представляем: Pepita
    Фреймворк JavaScript с открытым исходным кодом Я знаю, что недостатка в фреймворках JavaScript нет. Но я просто не мог остановиться. Я хотел написать что-то сам, со своими собственными..

    Советы по коду Laravel #2
    1-) Найти // You can specify the columns you need // in when you use the find method on a model User::find(‘id’, [‘email’,’name’]); // You can increment or decrement // a field in..

    Работа с временными рядами спутниковых изображений, часть 3 (аналитика данных)
    Анализ временных рядов спутниковых изображений для данных наблюдений за большой Землей (arXiv) Автор: Рольф Симоэс , Жильберто Камара , Жильберто Кейрос , Фелипе Соуза , Педро Р. Андраде ,..

    3 способа решить квадратное уравнение (3-й мой любимый) -
    1. Методом факторизации — 2. Используя квадратичную формулу — 3. Заполнив квадрат — Давайте поймем это, решив это простое уравнение: Мы пытаемся сделать LHS,..

    Создание VR-миров с A-Frame
    Виртуальная реальность (и дополненная реальность) стали главными модными терминами в образовательных технологиях. С недорогими VR-гарнитурами, такими как Google Cardboard , и использованием..

    Демистификация рекурсии
    КОДЕКС Демистификация рекурсии Упрощенная концепция ошеломляющей О чем весь этот шум? Рекурсия, кажется, единственная тема, от которой у каждого начинающего студента-информатика..