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 check

11:00:23  [mysql]   the Windows Event Viewer for more clues

11:00:23  [mysql]   If you need more help, copy and post this

11:00:23  [mysql]   entire log window on the forums

和 mysql_error.log

2019-09-13 11:16:14 0 [Note] InnoDB: Uses event mutexes

2019-09-13 11:16:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-09-13 11:16:14 0 [Note] InnoDB: Number of pools: 1

2019-09-13 11:16:14 0 [Note] InnoDB: Using SSE2 crc32 instructions

2019-09-13 11:16:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2019-09-13 11:16:14 0 [Note] InnoDB: Completed initialization of buffer pool

2019-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 tables

2019-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 start

2019-09-13 11:16:15 0 [Note] InnoDB: 10.3.16 started; log sequence number 19023759; transaction id 15037

2019-09-13 11:16:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool

2019-09-13 11:16:15 0 [Note] InnoDB: Buffer pool(s) load completed at 190913 11:16:15

2019-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

按照这个步骤，退出 Xampp 并导航到xampp/mysql/data目录删除ibdata1文件重新启动 XAMPP 服务器或者退出 Xampp 并导航到xampp/mysql/data目录删除ibdata1, ib_logfile0,ib_logfile1,ib_logfile101文件重新启动 XAMPP 服务器

Answer 2

xampp无法启动MySQL服务的原因有很多。手动启动 MySQL 服务End Task mysqld.exe1)Open Task Manager** > Progresses Tab > right click 'mysqld.exe' > end task2)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.