mysql 启动不了

[noobma]

系统是 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
[System] [MY-011012] [Server] Starting upgrade of data directory.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[ERROR] [MY-012936] [InnoDB] Database upgrade cannot be accomplished with innodb_force_recovery > 0
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[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

我是 mysql 菜鸡，技穷了，请各位大佬指点一手，现在是刚安装，没有数据，所以怎么搞都可以🙏

[skiy]

如果是我，我先用集成包尝试一下。如果能正常安装，那我再去看它的安装脚本是怎么写的。

[justin2018]

https://lnmp.org/ 这个可以试一试 😅

[noobma]

@skiy
@justin2018
谢谢大佬们，把现在的 mysql 删掉，加入 mysql 的源，从源里面重新安装，正常了😅

[wtks1]

其实如果只是尝试一下，完全可以用 docker 来装的，用别人做好的镜像，基本不会出问题

[ZehaiZhang]

一直都是 docker run 出来的🐶

[fhsan]

1 如果是我，apt-get
2 如果是我，make make install
3 偶尔会 dpkg，毕竟当初就是这样 debian 安装 sougou deb 的

[newtype0092]

你这就是有个旧表数据和新版 MySQL 不兼容啊，如果没有数据就是以前的遗留数据，去 data 文件夹下删空就行。

[zhangysh1995]

配置文件写错了吧 => 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.

[openbsd]

不是 glibc 一把梭吗 ？

[madpecker009]

@justin2018 mac 可以用这个吗？

[noobma]

@newtype0092 大佬你这一说，感觉是的，以前有个 mariadb，可能是 maria 的数据