无法登录phpmyadmin错误#1862-您的密码已过期 [英] cannot login to phpmyadmin error #1862 - Your password has expired

问题描述

我按照本教程. Evrything运作良好，也就是说，我可以通过命令行启动并连接到mysql，而没有任何错误，但是问题是当我尝试登录phpmyadmin时，出现了以下错误:

I installed mysql, php and phpmyadmin following this tutorial. Evrything works well, i.e., I can start and connect to mysql through the command line without any error, but the problem is when I try to login to phpmyadmin, I receive this error:

#1862-您的密码已过期.要登录，您必须使用 支持过期密码的客户端.

#1862 - Your password has expired. To log in you must change it using a client that supports expired passwords.

也许值得一提的是，我当前的mysql密码不是我安装mysql时收到的临时密码，但后来(在安装phpmyadmin之前)进行了更改，现在尝试使用此新的(当前)密码登录到phpmyadmin.向我显示了以上错误.

It might worth saying that my current mysql password is not the temporary one that I received when I installed mysql, but I changed it later (before installing phpmyadmin), and now trying to login to phpmyadmin with this new (current) password shows me the above error.

有人可以帮助我了解问题所在吗?

Could someone please help me understand what is the problem?

谢谢

推荐答案

好吧，最后我不明白造成此问题的原因是什么，但是以下解决方案对我有用:

Ok, finally I did not understand what was the reason for this issue, but the following solution worked for me:

1. 在终端(在/usr/local/mysql/bin/)中输入此内容mysqladmin -u root -p password
2. 输入密码

3. 输入新密码

1. Enter this in terminal (in /usr/local/mysql/bin/) mysqladmin -u root -p password
2. Enter your password

3. Enter New password

完成！然后我也可以从phpmyadmin登录！

Done! I could then login from phpmyadmin too!

希望它可以帮助有类似问题的其他人

Hope it help others who have similar problem,

这篇关于无法登录phpmyadmin错误#1862-您的密码已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！