无法重置根密码:windows、MySQL8.0 [英] Unable to reset Root Password: windows, MySQL8.0
本文介绍了无法重置根密码:windows、MySQL8.0的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我忘记了我的 root 密码,我正在关注 官方页面重置我的密码.我已按照确切的步骤操作.
I have forgotten my root password and I am following the official page to reset my password.I have followed the exact steps.
当我运行 sql-init.txt
文件时,我的 bash 卡住了,安装永远不会完成.
When I run the sql-init.txt
file my bash gets stuck and the installation never completes.
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 服务使其正常工作.
密码已设置为新密码.
The commandline was getting stuck. So , I had to close it forcefully(Ctrl+C).
Restarting my computer and MySQL services got it working.
Password was set to the new one.
这篇关于无法重置根密码:windows、MySQL8.0的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文