重启后 XAMPP MySQL 服务崩溃_数据库问题-得得之家

本文介绍了重启后 XAMPP MySQL 服务崩溃的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我刚刚安装了一个XAMPP 7.3.6-2-VC15 for Win64，安装后就没事了，MySQL从控制面板启动没有错误，一切正常.

I just install a XAMPP 7.3.6-2-VC15 for Win64, and when i install it, it's fine, MySQL start from control panel without error, et all is ok.

重新启动我的电脑后，Apache 仍在工作，但 MySQL 拒绝启动！我尝试重新安装 XAMPP，但它完全一样.MySQL 工作正常，重启后停止工作.

After rebooting my PC, Apache is still working, but MySQL refuse to start ! I try to reinstall XAMPP, but it's exactly the same. MySQL Work fine, and stop working after reboot.

这是我仅有的几条日志...

Here is THe few log i have...

在控制面板中:

09:48:10  [mysql]   Attempting to start MySQL app...
09:48:10  [mysql]   Status change detected: running
09:48:11  [mysql]   Status change detected: stopped
09:48:11  [mysql]   Error: MySQL shutdown unexpectedly.
09:48:11  [mysql]   This may be due to a blocked port, missing dependencies, 
09:48:11  [mysql]   improper privileges, a crash, or a shutdown by another method.
09:48:11  [mysql]   Press the Logs button to view error logs and check
09:48:11  [mysql]   the Windows Event Viewer for more clues
09:48:11  [mysql]   If you need more help, copy and post this
09:48:11  [mysql]   entire log window on the forums

在日志文件中:

2019-07-02  9:48:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-02  9:48:10 0 [Note] InnoDB: Uses event mutexes
2019-07-02  9:48:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-02  9:48:10 0 [Note] InnoDB: Number of pools: 1
2019-07-02  9:48:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-02  9:48:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-02  9:48:10 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-02  9:48:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1834407
2019-07-02  9:48:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-02  9:48:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-02  9:48:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-02  9:48:10 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-02  9:48:10 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2019-07-02  9:48:10 0 [Note] InnoDB: Waiting for purge to start
2019-07-02  9:48:10 0 [Note] InnoDB: 10.3.16 started; log sequence number 1834416; transaction id 265
2019-07-02  9:48:10 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2019-07-02  9:48:10 0 [Note] InnoDB: Buffer pool(s) load completed at 190702  9:48:10
2019-07-02  9:48:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-02  9:48:10 0 [Note] Server socket created on IP: '::'.

我尝试以下方法:

更改 3306 以外的端口 => 不成功
以管理员身份运行 xamp 控制面板 => 不成功
删除临时表 ibdata1 和 ibtmp1 => 不成功

如果有人有想法...

我尝试以管理员身份通过管理面板安装为 Windows 服务.所以，我在日志中有一些新行.似乎用户表已损坏...我该如何修复?

EDIT : I try to install as a windows service via admin panel as administrator. And so, i have some new lines in log. Seems user table is corrupted... how can i repair ?

2019-07-02 10:04:41 0 [ERROR] mysqld.exe: Table '.mysqluser' is marked as crashed and should be repaired
2019-07-02 10:04:41 0 [ERROR] mysqld.exe: Index for table '.mysqluser' is corrupt; try to repair it
2019-07-02 10:04:41 0 [ERROR] Couldn't repair table: mysql.user
2019-07-02 10:04:41 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'user' is corrupt; try to repair it

重启后 XAMPP MySQL 服务崩溃

问题描述

推荐答案

相关文档推荐