Error: MySQL shutdown unexpectedly.
8:33:32 AM [mysql] This may be due to a blocked port, missing dependencies,
8:33:32 AM [mysql] improper privileges, a crash, or a shutdown by another method.
8:33:32 AM [mysql] Press the Logs button to view error logs and check
8:33:32 AM [mysql] the Windows Event Viewer for more clues
8:33:32 AM [mysql] If you need more help, copy and post this
8:33:32 AM [mysql] entire log window on the forums
这是来自 XAMPP 消息本身。它以前在工作，突然间我似乎无法再次运行它。
InnoDB: using atomic writes.
2020-02-08 21:25:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-02-08 21:25:01 0 [Note] InnoDB: Uses event mutexes
2020-02-08 21:25:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-08 21:25:01 0 [Note] InnoDB: Number of pools: 1
2020-02-08 21:25:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-02-08 21:25:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-02-08 21:25:01 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-08 21:25:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-02-08 21:25:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-02-08 21:25:02 0 [Note] InnoDB: Setting file 'D:XAMPPmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-02-08 21:25:02 0 [Note] InnoDB: File 'D:XAMPPmysqldataibtmp1' size is now 12 MB.
2020-02-08 21:25:02 0 [Note] InnoDB: Waiting for purge to start
2020-02-08 21:25:02 0 [Note] InnoDB: 10.4.6 started; log sequence number 113872; transaction id 9
2020-02-08 21:25:02 0 [Note] InnoDB: Loading buffer pool(s) from D:XAMPPmysqldataib_buffer_pool
2020-02-08 21:25:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-08 21:25:02 0 [Note] InnoDB: Buffer pool(s) load completed at 200208 21:25:02
2020-02-08 21:25:02 0 [Note] Server socket created on IP: '::'.
这些来自mysql_error.log
首先尝试更改 xampp 控制器面板中的 apache 端口
转到配置 -> 服务和端口设置 -> apache 主端口 您可以在右侧找到MySQL选项卡
我想它需要您更改分配给mysql服务的端口 https://www.quora.com/How-do-I-change-the-port-of-a-MySQL-server-in-XAMPP
修复起来非常容易，只需按照以下步骤操作：-
- 打开Xampp控制面板
- 转到 Mysql 配置
- 打开我的.ini文件 (https://prnt.sc/1388sfe(
- 在屏幕截图中显示的两行中将端口更改为 3307 (https://prnt.sc/1388w0w(
- 保存并重新启动 Xampp。