错误：MySQL意外关闭。 Xampp
XAMPP 3.3.0 MySQL端口：3306 我检查了与此端口的任何冲突，发现
MySQL没有响应任何请求，无限加载，此后它将其关闭，而没有错误日志
XAMPP日志：
21:05:56 [mysql] Error: MySQL shutdown unexpectedly.
21:05:56 [mysql] This may be due to a blocked port, missing dependencies,
21:05:56 [mysql] improper privileges, a crash, or a shutdown by another method.
21:05:56 [mysql] Press the Logs button to view error logs and check
21:05:56 [mysql] the Windows Event Viewer for more clues
21:05:56 [mysql] If you need more help, copy and post this
21:05:56 [mysql] entire log window on the forums
MySql server logs:
1. 2022-06-18 21:07:34 0 [Note] InnoDB: Mutexes and rw_locks use
Windows interlocked functions
2022-06-18 21:07:34 0 [Note] InnoDB: Uses event mutexes
2022-06-18 21:07:34 0 [Note] InnoDB: Compressed tables use zlib
1.2.11
2022-06-18 21:07:34 0 [Note] InnoDB: Number of pools: 1
2022-06-18 21:07:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-18 21:07:34 0 [Note] InnoDB: Initializing buffer pool, total
size = 16M, instances = 1, chunk size = 16M
2022-06-18 21:07:34 0 [Note] InnoDB: Completed initialization of
buffer pool
2022-06-18 21:07:34 0 [Note] InnoDB: 128 out of 128 rollback
segments are active.
2022-06-18 21:07:34 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-06-18 21:07:34 0 [Note] InnoDB: Setting file
'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the
file full; Please wait ...
2022-06-18 21:07:34 0 [Note] InnoDB: File
'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-06-18 21:07:34 0 [Note] InnoDB: Waiting for purge to start
2022-06-18 21:07:35 0 [Note] InnoDB: 10.4.24 started; log sequence
number 3046387; transaction id 1396
2022-06-18 21:07:35 0 [Note] InnoDB: Loading buffer pool(s) from
C:\xampp\mysql\data\ib_buffer_pool
2022-06-18 21:07:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-18 21:07:35 0 [Note] Server socket created on IP: '::'.
XAMPP 3.3.0
MySql port: 3306
I checked any conflict with this port and found nothing
MySql doesn't respond to any request, infinite loading and after that it shuts down leaving no error logs
XAMPP logs:
21:05:56 [mysql] Error: MySQL shutdown unexpectedly.
21:05:56 [mysql] This may be due to a blocked port, missing dependencies,
21:05:56 [mysql] improper privileges, a crash, or a shutdown by another method.
21:05:56 [mysql] Press the Logs button to view error logs and check
21:05:56 [mysql] the Windows Event Viewer for more clues
21:05:56 [mysql] If you need more help, copy and post this
21:05:56 [mysql] entire log window on the forums
MySql server logs:
1. 2022-06-18 21:07:34 0 [Note] InnoDB: Mutexes and rw_locks use
Windows interlocked functions
2022-06-18 21:07:34 0 [Note] InnoDB: Uses event mutexes
2022-06-18 21:07:34 0 [Note] InnoDB: Compressed tables use zlib
1.2.11
2022-06-18 21:07:34 0 [Note] InnoDB: Number of pools: 1
2022-06-18 21:07:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-18 21:07:34 0 [Note] InnoDB: Initializing buffer pool, total
size = 16M, instances = 1, chunk size = 16M
2022-06-18 21:07:34 0 [Note] InnoDB: Completed initialization of
buffer pool
2022-06-18 21:07:34 0 [Note] InnoDB: 128 out of 128 rollback
segments are active.
2022-06-18 21:07:34 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
2022-06-18 21:07:34 0 [Note] InnoDB: Setting file
'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the
file full; Please wait ...
2022-06-18 21:07:34 0 [Note] InnoDB: File
'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-06-18 21:07:34 0 [Note] InnoDB: Waiting for purge to start
2022-06-18 21:07:35 0 [Note] InnoDB: 10.4.24 started; log sequence
number 3046387; transaction id 1396
2022-06-18 21:07:35 0 [Note] InnoDB: Loading buffer pool(s) from
C:\xampp\mysql\data\ib_buffer_pool
2022-06-18 21:07:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-18 21:07:35 0 [Note] Server socket created on IP: '::'.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您好！
只需执行以下简单步骤：
重命名文件夹
c：\ xampp \ mysql \ mysql \ data< < /strong> toc：\ xampp \ mysql \ data_old（或任何名称）
创建新文件夹
c：\ xampp \ mysql \ data复制
中的内容C：\ Xampp \ MySQL \ backuptoc：\ xampp \ mysql \ data文件夹复制
中的所有数据库文件夹c：\ xampp \ mysql \ data_oldtoc：\ xampp \ mysql \ data（skip performance_schema，mysql和来自
c：\ xampp \ mysql \ data_old）的phpmyadmin文件夹在
c：\ xampp \ mysql \ data文件夹中替换它。
现在从XAMPP控制面板重新启动mysql。
而且我确定这一切都已经完成...
Hello!
Just do these simple steps:
Rename the folder
C:\xampp\mysql\datatoC:\xampp\mysql\data_old(or any name)
Create new folder
C:\xampp\mysql\dataCopy the content that is inside
C:\xampp\mysql\backuptoC:\xampp\mysql\datafolderCopy all your database folders that are in
C:\xampp\mysql\data_oldtoC:\xampp\mysql\data(skip performance_schema, mysql andphpmyadmin folders from
C:\xampp\mysql\data_old)Finally copy the ibdata1 file from
C:\xampp\mysql\data_oldandreplace it inside
C:\xampp\mysql\datafolderNow Restart MySQL from XAMPP control panel.
And I am sure its all done...
我今天遇到了同样的问题，我通过删除所有master-xx.info文件和c：\ xampp \ mysql \ data中的所有master-xx.info文件和多master.info文件，
我再次启动它，它制造了一个新的空的多主掌握.info文件，并且效果很好。没有丢失数据
I had the same problem today and i fixed it by deleting all master-xx.info files and the multi-master.info file in C:\xampp\mysql\data
After I started it again it made a new and empty multi-master.info file and it worked perfectly fine again. No Data was lost
导航到CMD
写
Services.MSC
在出现的面板上找到myql
停止
享受
Navigate to CMD
Write
Services.msc
Find myql on the panel that comes up
Stop it
Enjoy