mysql - XAMPP 无法启动 mysql
问题描述
我不知道我的 xampp 中发生了什么。昨天还好,现在打开时出现这个错误
10:05:28 am [mysql] Status change detected: stopped
10:05:28 am [mysql] Error: MySQL shutdown unexpectedly.
10:05:28 am [mysql] This may be due to a blocked port, missing dependencies,
10:05:28 am [mysql] improper privileges, a crash, or a shutdown by another method.
10:05:28 am [mysql] Press the Logs button to view error logs and check
10:05:28 am [mysql] the Windows Event Viewer for more clues
10:05:28 am [mysql] If you need more help, copy and post this
10:05:28 am [mysql] entire log window on the forums
我尝试了几种解决方案,例如更改端口,但它不起作用。这是我的来自 mySQL 的日志
2021-02-03 10:05:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-03 10:05:26 0 [Note] InnoDB: Uses event mutexes
2021-02-03 10:05:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-03 10:05:26 0 [Note] InnoDB: Number of pools: 1
2021-02-03 10:05:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-03 10:05:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-03 10:05:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-03 10:05:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-03 10:05:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-03 10:05:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-03 10:05:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-03 10:05:26 0 [Note] InnoDB: Waiting for purge to start
2021-02-03 10:05:27 0 [Note] InnoDB: 10.4.11 started; log sequence number 5095927588; transaction id 88724
2021-02-03 10:05:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-03 10:05:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-03 10:05:27 0 [Note] Server socket created on IP: '::'.
解决方案
推荐阅读
- python - 单个 MongoDB 文档的过期不起作用
- sql - (SQL) 将日期条目和 date_update 列添加到现有 SQL 表
- android - 'Fluttertoast' 已被弃用,不应使用。将在后续版本中删除
- java-8 - 如何在指定文件中输出安全点日志?
- python - 通过动态生成的值(最新日期)过滤熊猫数据框中的行
- java - 如何在 android 应用程序中获取连接的外围设备列表(不是 android 的东西)
- javascript - 在运行时生成的 Vue 组件中添加或注入 HTML 或组件
- ios - Swift 自定义 URL 未从扩展程序打开应用程序
- javascript - Vue 中未调用计算属性集
- gitlab-ci - Gitlab-CI:条件变量?