MYSQL8无法启动的解决办法
故障现象:在计算机管理的服务里面,mysql无法启动。无法看到任何故障原因。
故障原因:Multiple files found for the same tablespace ID
解决办法:删除data目录下对应数据目录,本文是删除data\MYDATABASE目录。
故障调查过程:
step1:以管理员身份启动DOS,进入MYSQL的bin目录;
E:\mysql-8.0.14-winx64>cd bin
E:\mysql-8.0.14-winx64\bin>mysqld.exe --console
step2: 使用mysql --console查看故障原因。
可以看到:
E:\mysql-8.0.14-winx64\bin>mysqld.exe --console
2020-07-25T03:19:31.313285Z 0 [System] [MY-010116] [Server] E:\mysql-8.0.14-winx64\bin\mysqld.exe (mysqld 8.0.14) starting as process 12576
2020-07-25T03:19:31.315761Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-07-25T03:19:31.372675Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2020-07-25T03:19:31.372694Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 117 = ['MYDATABASE\routerconfig.ibd', 'MYDATABASE\imaging.ibd']
2020-07-25T03:19:31.372713Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-07-25T03:19:31.372744Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-07-25T03:19:31.372974Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-07-25T03:19:31.408786Z 0 [ERROR] [MY-010119] [Server] Aborting
可以看到故障的主要原因:Multiple files found for the same tablespace ID