mysql安装成功安装运行,每次电脑重启后,mysql无法启动【报错提示:本地计算机上的mysql服务启动后停止。某些服务在未由其他服务或程序使用时将自动停止】
软件环境:
mysql版本:mysql-8.0.18-winx64
windows版本:win10,64位
报错现象截图
每当电脑重启,mysql都无法启动,必须移除mysql重新安装mysql才可,这是什么原因导致的?每次开机移除安装mysql挺烦的
补充:
上述电脑重启,mysql无法启动,是在公司电脑上运行的;
在自己的电脑上测试一切正常;
猜测可能是公司电脑360企业安全云影响导致mysql无法启动。
--
2023.02.08
今天删除了360,再次测试,还是不行,查看mysql-err.log,提示如下:
2023-02-08T02:06:42.193642Z 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.
2023-02-08T02:06:42.644400Z 1 [ERROR] [MY-012224] [InnoDB] Checksum mismatch in datafile: mysql.ibd, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2023-02-08T02:06:42.646137Z 1 [ERROR] [MY-012131] [InnoDB] Could not find a valid tablespace file for mysql
. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2023-02-08T02:06:47.648215Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-02-08T02:06:47.649386Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-08T02:06:47.650436Z 0 [ERROR] [MY-010119] [Server] Aborting
--
这什么原因导致的,自己电脑是完全OK的;有可能是加密导致的吗?只要电脑重启就无法启动mysql,只能重装。