mysql - Failed to find valid data directory报错

2022-08-08T02:19:07.896712Z 0 [System] [MY-010116] [Server] E:\tool\mysql-8.0.30-winx64\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 33432
2022-08-08T02:19:07.927033Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7b76cbec-16c0-11ed-83af-ac9e17857e08.
2022-08-08T02:19:08.001395Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-08T02:19:08.002476Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-08T02:19:08.003806Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-08T02:19:08.005137Z 0 [System] [MY-010910] [Server] E:\tool\mysql-8.0.30-winx64\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
 
解决方法:

1、手动删掉自己创建的data文件夹
2、然后再管理员cmd下进入 bin 目录,移除自己的mysqld服务

3、在cmd的bin目录执行 mysqld --initialize-insecure
程序会在动MySQL文件夹下创建data文件夹以及对应的文件
4、bin目录下执行,mysqld --install ,安装mysqld服务
5、在bin目录下运行net start mysql ,启动mysql服务。

posted @ 2022-08-08 10:27  黑羽青衣  阅读(2211)  评论(0编辑  收藏  举报