mysql - XAMPP MySQL 意外关闭
问题描述
试图在 XAMPP 中运行 MySQL,但它不会启动,在错误日志中得到了这个:
InnoDB: using atomic writes.
2020-07-09 16:43:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-09 16:43:24 0 [Note] InnoDB: Uses event mutexes
2020-07-09 16:43:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-09 16:43:24 0 [Note] InnoDB: Number of pools: 1
2020-07-09 16:43:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-09 16:43:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk > size = 16M
2020-07-09 16:43:25 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-09 16:43:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-09 16:43:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-09 16:43:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB.
Physically writing the file full; Please wait ...
2020-07-09 16:43:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-09 16:43:26 0 [Note] InnoDB: Waiting for purge to start
2020-07-09 16:43:26 0 [Note] InnoDB: 10.4.6 started; log sequence number 192714408; transaction id 58253
2020-07-09 16:43:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-09 16:43:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-09 16:43:26 0 [Note] Server socket created on IP: '::'.
这是 XAMPP 命令日志中显示的内容:
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums
请帮忙
解决方案
推荐阅读
- cuda - cuda 驱动程序安装失败(ubuntu 14.04)
- mysql - 根据 MySQL 中的重复列删除行
- java - 找不到 hbase.mapreduce.TableOutputFormat
- javascript - Vuex:通过 axios on action 获取数据后无法使页面反应
- angular - Angular2中的全局“悬停触发功能”
- python - 分块处理数据时如何 pd.merge(..., on="column", ...) ?
- excel - 打开不指定名称的excel文件
- javascript - 尝试使用 Nodejs 从 HTML 响应中提取信息
- .net-core - 作为数据库迁移的一部分迁移数据
- spring - JpaItemWriter MultiThreader 主键冲突