mysql - XAMPP MySQL 意外关闭
问题描述
对为什么我的 XAMPP 不再工作感到困惑。过去一个月我一直在使用它,它一直按预期工作,截至今天,当我设置它并尝试运行 MySQL 时,一个错误导致它无法正常运行。我的 Apache 运行良好,但 MySQL 不行。
这是在 MySQL 错误日志中:
InnoDB: using atomic writes.
2020-05-02 18:24:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-02 18:24:01 0 [Note] InnoDB: Uses event mutexes
2020-05-02 18:24:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-02 18:24:01 0 [Note] InnoDB: Number of pools: 1
2020-05-02 18:24:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-02 18:24:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-05-02 18:24:01 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-02 18:24:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-02 18:24:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-02 18:24:02 0 [Note] InnoDB: Setting file '\uniyear3\NathanBayne_wst1\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-02 18:24:02 0 [Note] InnoDB: File '\uniyear3\NathanBayne_wst1\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-05-02 18:24:03 0 [Note] InnoDB: Waiting for purge to start
2020-05-02 18:24:03 0 [Note] InnoDB: 10.4.11 started; log sequence number 356547; transaction id 344
2020-05-02 18:24:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-02 18:24:03 0 [Note] InnoDB: Loading buffer pool(s) from G:\uniyear3\NathanBayne_wst1\xampp\mysql\data\ib_buffer_pool
2020-05-02 18:24:03 0 [Note] Server socket created on IP: '::'.
这是我的 Apache 错误日志:
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite' (tried: \\uniyear3\\NathanBayne_wst1\\xampp\\php\\ext\\pdo_sqlite (The specified module could not be found.), \\uniyear3\\NathanBayne_wst1\\xampp\\php\\ext\\php_pdo_sqlite.dll (The specified module could not be found.)) in Unknown on line 0
[Sat May 02 18:23:54.452382 2020] [mpm_winnt:notice] [pid 2312:tid 640] AH00455: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.4 configured -- resuming normal operations
[Sat May 02 18:23:54.452382 2020] [mpm_winnt:notice] [pid 2312:tid 640] AH00456: Apache Lounge VC15 Server built: Aug 11 2019 12:20:04
[Sat May 02 18:23:54.452382 2020] [core:notice] [pid 2312:tid 640] AH00094: Command line: 'g:\\uniyear3\\nathanbayne_wst1\\xampp\\apache\\bin\\httpd.exe -d G:/uniyear3/NathanBayne_wst1/xampp/apache'
[Sat May 02 18:23:54.455341 2020] [mpm_winnt:notice] [pid 2312:tid 640] AH00418: Parent: Created child process 2192
[Sat May 02 18:23:54.653167 2020] [ssl:warn] [pid 2192:tid 648] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat May 02 18:23:54.693962 2020] [ssl:warn] [pid 2192:tid 648] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite' (tried: \\uniyear3\\NathanBayne_wst1\\xampp\\php\\ext\\pdo_sqlite (The specified module could not be found.), \\uniyear3\\NathanBayne_wst1\\xampp\\php\\ext\\php_pdo_sqlite.dll (The specified module could not be found.)) in Unknown on line 0
[Sat May 02 18:23:54.712700 2020] [mpm_winnt:notice] [pid 2192:tid 648] AH00354: Child: Starting 150 worker threads.
8:24:06 [mysql] Error: MySQL shutdown unexpectedly. 18:24:06 [mysql] This may be due to a blocked port, missing dependencies,
18:24:06 [mysql] improper privileges, a crash, or a shutdown by another method. 18:24:06 [mysql] Press the Logs button to view error logs and check 18:24:06 [mysql] the Windows Event Viewer for more clues
18:24:06 [mysql] If you need more help, copy and post this 18:24:06 [mysql] entire log window on the forums
解决方案
推荐阅读
- r - 从 R 中的字符向量中从/到特定单词中提取字符串
- amazon-web-services - Terraform - 将变量输出为引用值
- python - 如何获得列的所有值之间的绝对差异?
- core-data - 编辑 CoreData 和视图的更新
- git - 如何将嵌套存储库(子模块)视为普通目录?
- html - 内容可编辑错误不适用于删除按钮
- python - 在 Python Pandas 中使用多个通配符
- multithreading - 如何同时启动多个 Future 以填充单个 FutureBuilder ListView?
- reactjs - React Hooks:从 useEffect() 引用存储在上下文中的数据
- flutter - 集成测试时如何解决 Flutter 中请求“dart.ui”的问题