第一步:找到mysqld.log ----- 我的log位置在var/log
2023-01-11T01:42:49.584737Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 5435
2023-01-11T01:42:49.593816Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-11T01:42:49.601028Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2023-01-11T01:42:49.601080Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 74 = ['xxxx/approve_flow_detail.ibd', 'xxx/@5ba3@4f20@6559@80b2@00282@0029.ibd']
2023-01-11T01:42:49.601126Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2023-01-11T01:42:49.601157Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-01-11T01:42:49.601326Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-01-11T01:42:49.601354Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-01-11T01:42:49.602194Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL.
2023-01-11T01:46:22.714262Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 5896
2023-01-11T01:46:22.723028Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-11T01:46:22.864089Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-11T01:46:23.210392Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-01-11T01:46:23.210452Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-01-11T01:46:23.239200Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-01-11T01:46:23.239300Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
颜色标记的地方是出现问题的,找到对应文件删除,重新建表导入数据即可
第二步:重启mysql,systemctl restart mysqld,启动成功
备注:每个人出现的问题都不一样,根据错误日志逐步纠正,问题即可解决,摸索了几个小时,希望能帮到大家