ChenYiXin2013310 2022-12-19 11:16 采纳率: 81.8%
浏览 24
已结题

我把MySQL的data删了

img

C:\Windows\System32>mysqld --initialize-insecure --user=mysql
mysqld: Can't create directory 'D: ofeware\MySQL\mysql-8.0.26-winx64\data\' (OS errno 2 - No such file or directory)
2022-12-19T03:10:53.939526Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2022-12-19T03:10:53.939541Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.31-winx64\bin\mysqld.exe (mysqld 8.0.31) initializing of server in progress as process 776
2022-12-19T03:10:53.939653Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'D:\ ofeware\MySQL\mysql-8.0.26-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2022-12-19T03:10:53.941753Z 0 [ERROR] [MY-010187] [Server] Could not open file 'D: ofeware\MySQL\mysql-8.0.26-winx64\data\DESKTOP-MC3ROCD.err' for error logging: Permission denied
2022-12-19T03:10:53.943165Z 0 [ERROR] [MY-013236] [Server] The designated data directory D: ofeware\MySQL\mysql-8.0.26-winx64\data\ is unusable. You can remove all files that the server added to it.
2022-12-19T03:10:53.943534Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-12-19T03:10:53.943675Z 0 [System] [MY-010910] [Server] D:\Program Files\mysql-8.0.31-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.31)  MySQL Community Server - GPL.

我把data目录删了,看了网上的博客才知道是不能删的,好难过┭┮﹏┭┮

  • 写回答

4条回答 默认 最新

  • 於黾 2022-12-19 11:27
    关注

    从别人那拷贝一个回来,或者重装mysql

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

问题事件

  • 系统已结题 7月4日
  • 已采纳回答 6月26日
  • 创建了问题 12月19日