gpt4 book ai didi

mysql - MySQL8.0无法重置root密码: windows,

转载 作者:行者123 更新时间:2023-11-29 09:49:58 25 4
gpt4 key购买 nike

我忘记了我的 root 密码,我正在关注official page重置我的密码。我已按照确切的步骤操作。

当我运行 sql-init.txt 文件时,我的 bash 被卡住并且安装永远无法完成。

C:\Windows\system32>cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 8.0\\my.ini" --init-file=C:\\mysql-init.txt --console
2019-03-04T12:06:43.930229Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-03-04T12:06:43.932934Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.15) starting as process 2556
2019-03-04T12:06:48.805422Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-03-04T12:06:48.996196Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.15' socket: '' port: 3306 MySQL Community Server - GPL.
2019-03-04T12:06:49.078797Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

请指导。

最佳答案

命令行卡住了。所以,我不得不强行关闭它(Ctrl+C)。重新启动我的计算机,MySQL 服务就可以正常工作了。
密码已设置为新密码。

关于mysql - MySQL8.0无法重置root密码: windows,,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/54982970/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com