2023-02-11 14:07

mysql8服务器The innodb_system data file 'ibdata1' must be writable导致无法启动服务器

王姐姐

数据库

(437)

(0)

收藏

mysql服务器突然启动不起来了,查看日志,显示如下错误:

2023-02-11T05:23:21.555101Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable

2023-02-11T05:23:21.555669Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable

2023-02-11T05:23:21.556238Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine

2023-02-11T05:23:21.556966Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

image.png

删除配置文件中datadir的目录下面的两个文件即可:

image.png

0条评论

点击登录参与评论