mysql8.0.28 启动失败
查看mysql 日志中打印的信息cat /var/log/mysqld.log2022-04-12T11:22:33.159866Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28) initializing of server in progress as process 434762022-04-12T11:22:
·
查看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 文件里修改数据数据目录到其他位置，然后修改属主，重新启动就启动起来了
魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)