XAMPP 启动不了 MySql
程序员文章站
2022-03-06 16:12:57
...
XAMPP启动不了MySql
查看端口 应该没有被占用
15:17:37 [mysql] Error: MySQL shutdown unexpectedly.
15:17:37 [mysql] This may be due to a blocked port, missing dependencies,
15:17:37 [mysql] improper privileges, a crash, or a shutdown by another method.
15:17:37 [mysql] Press the Logs button to view error logs and check
15:17:37 [mysql] the Windows Event Viewer for more clues
15:17:37 [mysql] If you need more help, copy and post this
15:17:37 [mysql] entire log window on the forums
140504 15:17:36 [Note] Plugin 'FEDERATED' is disabled.
140504 15:17:36 InnoDB: The InnoDB memory heap is disabled
140504 15:17:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140504 15:17:36 InnoDB: Compressed tables use zlib 1.2.3
140504 15:17:36 InnoDB: Initializing buffer pool, size = 16.0M
140504 15:17:36 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file F:\xampp\mysql\data\ibdata1
140504 15:17:36 InnoDB: Could not open or create data files.
140504 15:17:36 InnoDB: If you tried to add new data files, and it failed here,
140504 15:17:36 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140504 15:17:36 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140504 15:17:36 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140504 15:17:36 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140504 15:17:36 InnoDB: remove old data files which contain your precious data!
140504 15:17:36 [ERROR] Plugin 'InnoDB' init function returned error.
140504 15:17:36 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140504 15:17:36 [ERROR] Unknown/unsupported storage engine: InnoDB
140504 15:17:36 [ERROR] Aborting
140504 15:17:36 [Note] f:\xampp\mysql\bin\mysqld.exe: Shutdown complete
查看端口 应该没有被占用
15:17:37 [mysql] Error: MySQL shutdown unexpectedly.
15:17:37 [mysql] This may be due to a blocked port, missing dependencies,
15:17:37 [mysql] improper privileges, a crash, or a shutdown by another method.
15:17:37 [mysql] Press the Logs button to view error logs and check
15:17:37 [mysql] the Windows Event Viewer for more clues
15:17:37 [mysql] If you need more help, copy and post this
15:17:37 [mysql] entire log window on the forums
140504 15:17:36 [Note] Plugin 'FEDERATED' is disabled.
140504 15:17:36 InnoDB: The InnoDB memory heap is disabled
140504 15:17:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140504 15:17:36 InnoDB: Compressed tables use zlib 1.2.3
140504 15:17:36 InnoDB: Initializing buffer pool, size = 16.0M
140504 15:17:36 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file F:\xampp\mysql\data\ibdata1
140504 15:17:36 InnoDB: Could not open or create data files.
140504 15:17:36 InnoDB: If you tried to add new data files, and it failed here,
140504 15:17:36 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140504 15:17:36 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140504 15:17:36 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140504 15:17:36 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140504 15:17:36 InnoDB: remove old data files which contain your precious data!
140504 15:17:36 [ERROR] Plugin 'InnoDB' init function returned error.
140504 15:17:36 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140504 15:17:36 [ERROR] Unknown/unsupported storage engine: InnoDB
140504 15:17:36 [ERROR] Aborting
140504 15:17:36 [Note] f:\xampp\mysql\bin\mysqld.exe: Shutdown complete
回复讨论(解决方案)
你是一开始就出问题,还是做了什么后才出问题的?
可能是因为 点击 打开的时候 系统弹出了个安全对话框 我选中了保持阻止
不过现在重装了下 已经可以 谢谢啊
推荐阅读
-
windows无法启动MySQL服务报错1067的解决方法
-
阿里云ECS云服务器(linux系统)安装mysql后远程连接不了(踩坑)
-
MySQL服务器的启动和关闭
-
mysql-8.0.15-winx64 使用zip包进行安装及服务启动后立即关闭问题
-
sql server启动不了, MSSQL 18052错误: 9003,严重度: 20,状态: 1 .
-
XAMPP中Apache能启动但MySql无法启动解决方法
-
安装xampp后apache无法启动的原因及解决方法
-
Win7系统下adb.exe工具包启动不了的解决方法
-
电脑插4根内存开不了机拔掉两根内存可以正常启动
-
windows版本下mysql的安装启动和基础配置图文教程详解