centos8 when i download mysql8 and systemctl start mysqld. Always can’t start.
my error log:
2024-05-10T07:52:56.902850Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37) starting as process 50584
2024-05-10T07:52:56.913882Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-05-10T07:52:57.656220Z 1 [ERROR] [MY-012224] [InnoDB] Checksum mismatch in datafile: mysql.ibd, Space ID:4294967294, Flags: 18432. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2024-05-10T07:52:57.656266Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2024-05-10T07:52:57.656280Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2024-05-10T07:52:57.656304Z 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 – )
2024-05-10T07:52:57.955000Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-05-10T07:52:57.955229Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-10T07:52:57.955269Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-10T07:52:57.956115Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37) MySQL Community Server – GPL.
1.i tried 8.0.26 and same issue.
2.delete /var/lib/mysql/. same issue.
3.chmod and chown. same issue.
maybe the mysql.ibd problems? but how to fix it?
wyc is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.