守·纪 2020-03-26 11:43 采纳率: 0%
浏览 843

mysql出现1058错误怎么办?

上次好不容易修好的mysql,又坏了......

  • 运行环境:win10,,mysql5.7×86,Python
  • 错误号:1058
Microsoft Windows [版本 10.0.18363.720]
(c) 2019 Microsoft Corporation。保留所有权利。

C:\WINDOWS\system32>net start mysql
发生系统错误 1058。

无法启动服务,原因可能是已被禁用或与其相关联的设备没有启动。

C:\WINDOWS\system32>cd C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin

C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld -nt -remove
mysqld: Can't change dir to 'D:\mysql-8.0.19-winx64\data\' (Errcode: 2 - No such file or directory)
2020-03-26T02:12:41.852949Z 0 [Warning] option 'new': boolean value 't' wasn't recognized. Set to OFF.
2020-03-26T02:12:41.883456Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2020-03-26T02:12:41.905031Z 0 [Note] mysqld (mysqld 5.7.29) starting as process 8040 ...
2020-03-26T02:12:41.923222Z 0 [ERROR] Can't find error-message file 'D:\mysql-8.0.19-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2020-03-26T02:12:42.116629Z 0 [Warning] Can't create test file D:\mysql-8.0.19-winx64\data\Lenovo-PC.lower-test
2020-03-26T02:12:42.117403Z 0 [Warning] Can't create test file D:\mysql-8.0.19-winx64\data\Lenovo-PC.lower-test
2020-03-26T02:12:42.119014Z 0 [ERROR] failed to set datadir to D:\mysql-8.0.19-winx64\data\
2020-03-26T02:12:42.119832Z 0 [ERROR] Aborting

2020-03-26T02:12:42.160124Z 0 [Note] Binlog end
2020-03-26T02:12:42.203965Z 0 [Note]

C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>

我用的是5.7,但错误文件里显示的我用的好像是...8.0.19???

  • 写回答

1条回答 默认 最新

  • Json-Huang 2020-03-26 11:59
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 stata安慰剂检验作图但是真实值不出现在图上
  • ¥15 c程序不知道为什么得不到结果
  • ¥40 复杂的限制性的商函数处理
  • ¥15 程序不包含适用于入口点的静态Main方法
  • ¥15 素材场景中光线烘焙后灯光失效
  • ¥15 请教一下各位,为什么我这个没有实现模拟点击
  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题