xampp 不启动 mysql

Question

我使用 xampp-windows-x64。以前我可以在 xampp 中打开 mysql。但经过我重新启动我的笔记本电脑，我无法打开mysql的xampp控制。这个日志：11:00:23  [mysql]   Error: MySQL shutdown unexpectedly.11:00:23  [mysql]   This may be due to a blocked port, missing dependencies, 11:00:23  [mysql]   improper privileges, a crash, or a shutdown by another method.11:00:23  [mysql]   Press the Logs button to view error logs and check11:00:23  [mysql]   the Windows Event Viewer for more clues11:00:23  [mysql]   If you need more help, copy and post this11:00:23  [mysql]   entire log window on the forums和 mysql_error.log2019-09-13 11:16:14 0 [Note] InnoDB: Uses event mutexes2019-09-13 11:16:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.112019-09-13 11:16:14 0 [Note] InnoDB: Number of pools: 12019-09-13 11:16:14 0 [Note] InnoDB: Using SSE2 crc32 instructions2019-09-13 11:16:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M2019-09-13 11:16:14 0 [Note] InnoDB: Completed initialization of buffer pool2019-09-13 11:16:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.2019-09-13 11:16:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables2019-09-13 11:16:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...2019-09-13 11:16:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.2019-09-13 11:16:15 0 [Note] InnoDB: Waiting for purge to start2019-09-13 11:16:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 19023759; transaction id 150372019-09-13 11:16:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool2019-09-13 11:16:15 0 [Note] InnoDB: Buffer pool(s) load completed at 190913 11:16:152019-09-13 11:16:15 0 [Note] Plugin 'FEEDBACK' is disabled.2019-09-13 11:16:15 0 [Note] Server socket created on IP: '::'.如何从 xampp 启动 mysql？

Answer 1

按照这个步骤，

1. 退出 Xampp 并导航到xampp/mysql/data目录

2. 删除ibdata1文件

3. 重新启动 XAMPP 服务器

或者

1. 退出 Xampp 并导航到xampp/mysql/data目录

2. 删除ibdata1, ib_logfile0,ib_logfile1,ib_logfile101文件

3. 重新启动 XAMPP 服务器

Answer 2

xampp无法启动MySQL服务的原因有很多。手动启动 MySQL 服务

End Task mysqld.exe

1)Open Task Manager** > Progresses Tab > right click 'mysqld.exe' > end task

2)Open your services.msc by Run (press 'Window + R') > services.msc or 0n your XAMPP ControlPanel, click 'Services' button. Find 'MySQL' service, right click and run it.