不出问题一路next,出了问题才发现无从下手。居然没有记录错误的日志。
多方查找与尝试,找到解决方案。
直接在MySQL安装目录下,运行:mysqld --console
这样可以看到启动信息与错误提示。
我的提示
2023-02-07T15:09:08.567200Z 1 [ERROR] [MY-012271] [InnoDB] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-02-07T15:09:08.568178Z 1 [ERROR] [MY-012278] [InnoDB] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-02-07T15:09:08.568701Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-02-07T15:09:08.569753Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-07T15:09:08.569827Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-07T15:09:08.572348Z 0 [System] [MY-010910] [Server] C:\phpstudy_pro\Extensions\MySQL8.0.12\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
听说删除data目录2个ib_logfile。我试了,又有新的错误。
ysqld: File '.\binlog.000061' not found (OS errno 2 - No such file or directory)
2023-02-07T15:14:33.559138Z 0 [ERROR] [MY-010811] [Server] Failed to open log (file '.\binlog.000061', errno 2)
2023-02-07T15:14:33.559583Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2023-02-07T15:14:33.559650Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2023-02-07T15:14:33.559958Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-07T15:14:34.814864Z 0 [System] [MY-010910] [Server] C:\phpstudy_pro\Extensions\MySQL8.0.12\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
这个是我清理日志清掉了。
可是还被谁惦记着呢?
原来是binlog.index
打开,删除不存在的日志文件名(我直接清空了)
再次启动。成功!