XAMPP在Windows下MySql启动Crash-优快云博客

本文链接：https://blog.youkuaiyun.com/chriscross/article/details/88351009

本文记录了在XAMPP环境下遇到的MySql启动后立即停止的问题，通过查看错误日志发现可能的原因包括端口被阻塞、依赖缺失、权限不当等。最终通过在my.ini中增加一行代码innodb_flush_method=normal成功解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

XAMPP在Windows下MySql启动Crash

XAMPP出错提示

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

MySql错误日志

Server version: 10.1.38-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=1001
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 787931 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
mysqld.exe!my_parameter_handler()
mysqld.exe!strxnmov()
mysqld.exe!strxnmov()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!parse_user()
mysqld.exe!?ha_initialize_handlerton@@YAHPEAUst_plugin_int@@@Z()
mysqld.exe!?plugin_init@@YAHPEAHPEAPEADH@Z()
mysqld.exe!?plugin_init@@YAHPEAHPEAPEADH@Z()
mysqld.exe!?init_net_server_extension@@YAXPEAVTHD@@@Z()
mysqld.exe!?win_main@@YAHHPEAPEAD@Z()
mysqld.exe!?mysql_service@@YAHPEAX@Z()
mysqld.exe!?mysqld_main@@YAHHPEAPEAD@Z()
mysqld.exe!strxnmov()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

解决方法

打开Mysql的配置文件my.ini

...（省略）
innodb_lock_wait_timeout = 50
# 增加下面这一行，重启Mysql
innodb_flush_method=normal
## UTF 8 Settings
...（省略）