mysql 启动不起来_mysql 启动不了

最新推荐文章于 2024-05-17 16:54:51 发布

weixin_39633781

最新推荐文章于 2024-05-17 16:54:51 发布

阅读量2.9k

点赞数

文章标签： mysql 启动不起来

本文链接：https://blog.csdn.net/weixin_39633781/article/details/113169646

版权

系统是 debian 10，跟着这个文档下载安装了 mysql 8.0.21, 不过在执行 dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb 的时候有依赖错误，所以我手动拆开成了几条命令先后执行，然后安装也成功了

dpkg -i mysql-common...deb

dpkg -i mysql-community-client...deg

dpkg -i mysql-client...deb

dpkg -i mysql-community-server...deb

dpkg -i mysql-server...deb

但是启动的时候报错

[MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 2029

[System] [MY-011012] [Server] Starting upgrade of data directory.

[System] [MY-013576] [InnoDB] InnoDB initialization has started.

[ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

[ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.

[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.

[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

[ERROR] [MY-010119] [Server] Aborting

[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL

我跟着错误日志中的链接去设置了 innodb_force_recovery = 1, 再重启 systemctl restart mysql.service , 又报错了

[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 1169