1、问题截图

cat /var/log/mysql/error.log

2019-01-28T09:49:57.076019Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4800!

2、问题原因

InnoDB的问题。原来安装的是mysql8.0版本，比现在的5.7版本要高，但在高版本数据库时创建的一些数据库数据都还在，使用的是高版本的InnoDB引擎，而低版本的数据库服务还是指向了这些数据，但是一些版本的数据格式不同，这个时候，我们只要把高版本的数据删掉就可以了，删掉后重新启动mysql就可以了。

3、解决办法

rm -R /var/lib/mysql

本栏目推荐文章
• AtCoder World Tour 2022 B The Greatest Two
• Introducing the incident management
• A connection was successfully established with the server but then an error
• An improved LSTM-based model for identifying high working intensity load segments of the tractor load spectrum
• web项目启动时dubbo报错： No provider available for the service com.davidhu.shopguide.api.service.UserEventService from the url zookeeper ://localhost:2181/org.apache.du
• 初中英语优秀范文100篇-056I have the courage to accept the challenge-我有勇气接受挑战
• mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; ERROR 1410 (42000): You are not allowed to create a user with GRANT
• org.springframework.kafka.listener.ListenerExecutionFailedException: Listener method could not be invoked with the incoming message
• redis报错MISCONF Errors writing to the AOF file: No space left on device，磁盘满无法写入数据报错
• [linux kernel] struct pid && the way the kernel used to cast uint32_t pid to struct task_struct

flags dictionary are the ibdata1flags dictionary are the ibdata1 innodb_system writable ibdata1 innodb are le_expressing_who_you_are are operation datanode excluded microservices microservice are what coci 2011 2012 are building_something_for_others_whi le_expressing_who_you_are 1039d given tree are