计算机知识分享网

【mysql】MySQL5.7解决密码过期问题

使用navicat链接数据库时,报错

ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.

翻译:
错误1862(HY000):你的密码已经过期。登录必须改变它使用一个客户端,支持过期的密码
解决办法:
D:\KaiFaGongJu\mysql-5.7.40-winx64\bin>mysqladmin -uroot -p password
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

D:\davidzheng\mysql-5.7.40-winx64\bin>mysqladmin -uroot -p password
Enter password: ************ //这里输入上面的过期密码:v:xdfa23ff
New password: ******  // 输入新密码
Confirm new password: ****** //重新输入新密码
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

#Mysql