随机错误:#1045无法登录MySQL服务器 [英] Random error: #1045 Cannot log in to the MySQL server
问题描述
我已经有一个月启动并运行了mysql.昨天我在使用它,今天我通过phpmyadmin和命令行登录,但突然之间无法使用.好像有人在一夜之间更改了我的密码一样.我试图使用root用户登录.我该怎么办?
Ive had mysql up and running for month now. I was using it yesterday, and today I go to login via phpmyadmin and the command line and I suddenly can't. Its as if someone changed my password overnight or something. Im trying to login using the root user. What do I do?
修改
这是mysql,仅在我的本地笔记本电脑上运行以进行开发.唯一的帐户是root帐户,并且没有大写锁定.
This is mysql just running on my local laptop for development. The only account on it is the root account, and no caps lock is not on.
推荐答案
我使用了链接 raina77ow提供并按照说明重置了我的密码,并且现在可以使用.
I used the link raina77ow provided and followed the instructions to reset my password and it works now.
向下滚动到 C.5.4.1.3部分.重置根密码:通用说明 特别有用.
Scrolling down to section C.5.4.1.3. Resetting the Root Password: Generic Instructions was particularly helpful.
这篇关于随机错误:#1045无法登录MySQL服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!