mysql8.0.28 启动失败

骑着蜗牛去看北极光

已于 2022-04-14 22:07:45 修改

阅读量7.2k

点赞数

文章标签：数据库架构

于 2022-04-14 22:04:47 首次发布

本文链接：https://blog.youkuaiyun.com/qq_47904804/article/details/124182679

版权

在尝试启动MySQL 8.0.28时遇到错误，日志显示数据目录 `/var/lib/mysql/` 不可用。解决方法包括删除该目录下所有文件，然后在 `/etc/my.cnf` 配置文件中更改数据目录到其他位置，并调整目录权限。完成这些步骤后，成功重启MySQL服务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查看mysql 日志中打印的信息

cat /var/log/mysqld.log

2022-04-12T11:22:33.159866Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28) initializing of server in progress as process 43476
2022-04-12T11:22:33.161391Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.  
2022-04-12T11:22:33.161425Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2022-04-12T11:22:33.161518Z 0 [ERROR] [MY-010119] [Server] Aborting   
2022-04-12T11:22:33.161692Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28)  MySQL Community Server - GPL.
2022-04-12T11:22:33.368100Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28) starting as process 43479
2022-04-12T11:22:33.384508Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-04-12T11:22:33.384678Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-04-12T11:22:33.384744Z 0 [ERROR] [MY-010119] [Server] Aborting

2022-04-12T11:22:33.161425Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.

指定的数据目录 /var/lib/mysql/ 不可用。您可以删除服务器添加到其中的所有文件。

报错提示这个这个数据目录不可用，然后在、/etc/my.cof 文件里修改数据数据目录到其他位置，然后修改属主，重新启动就启动起来了