mysql安装报错解决

mysql在输入mysqld --initialize --console后出现报错
报错内容如下:

mysqld: Can't create directory 'E:\java瀛︿範鏂囨。\mysql-8.0.16-winx64\data\' (OS errno 2 - No such file or directory)
2021-07-29T01:21:23.596463Z 0 [System] [MY-013169] [Server] E:\javaData\mysql-8.0.16-winx64\bin\mysqld.exe (mysqld 8.0.16) initializing of server in progress as process 16852
2021-07-29T01:21:23.596878Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'E:\java瀛︿範鏂囨。\mysql-8.0.16-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2021-07-29T01:21:23.597960Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-07-29T01:21:23.597978Z 0 [Warning] [MY-013242] [Server] --character-set-filesystem: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-07-29T01:21:23.600696Z 0 [ERROR] [MY-013236] [Server] Newly created data directory E:\java瀛︿範鏂囨。\mysql-8.0.16-winx64\data\ is unusable. You can safely remove it.
2021-07-29T01:21:23.604666Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-29T01:21:23.604936Z 0 [System] [MY-010910] [Server] E:\javaData\mysql-8.0.16-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.

解决方案:

  1. 地址目录名不可包含中文—更改地址目录文件名称
  2. 在控制面板中的高级系统设置中的path也需要更改地址目录
  3. 在my.ini文件中 也需要将basedir和datadir更改

再次运行mysqld --initialize --console后问题解决

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值