守·纪 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 树莓派与pix飞控通信
  • ¥15 自动转发微信群信息到另外一个微信群
  • ¥15 outlook无法配置成功
  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题