Your password has expired. To log in you must change it using a client that supports expired pa

最新推荐文章于 2023-07-17 10:32:19 发布
最新推荐文章于 2023-07-17 10:32:19 发布
阅读量671 收藏
点赞数
分类专栏： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_42691309/article/details/88189358
版权

这个是初始密码问题，有两张方法，我这里用的是命令行的方法，即进入相应mysql目录，再修改密码的方法。

首先输入mysqld --defaults-file="F:/Program Files (x86)/MySQL/my.ini"  --skip-grant-tables:

输入临时密码

登陆，然后修改密码（注意8.0以后的修改语句有所不同）

navicat输入新密码后可正常连接数据库：

Cherry Xie
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a .....
09-09
当你在安装 MySQL过程中，通过mysqld --initialize 初始化 mysql 操作后，生成临时密码后，没有直接进行 MySQL连接，中途重启服务或者重启机器等，导致密码失效问题，怎么处理呢，感兴趣的朋友一起看看吧
Dockerfile reference翻译
weixin_43406695的博客
04-03 396
对官方文档的粗略翻译
Iptables Tutorial 1.2.1（3）
子曰小玖的博客
05-20 1832
Chapter 12. Debugging your scripts One of the big and underestimated sides of writing your own rulesets is how to debug the rulesets on your own, and how to find where you have done your mistakes in the rulesets. This chapter will show you a few basic ste
Your password has expired. To log in you must change it using a client that supports expired passwod
我这么骄傲的一个人。
12-23 1万+
最近在做毕业设计项目，前几天连接数据库都没有遇到问题，但是今天连接数据库时一直连接不上,感觉非常纳闷，一直报如下错误： Your password has expired. To log in you must change it using a client that supports expired passwords.
your password has expired.To log in you must change itusing a client that supports expired passwords
热门推荐
fenniang16的博客
07-26 4万+
学java当然就少不了要跟mySQL打交道，终于经历了2小时的恶心安装后，舒舒服服的敲了一天demo，第二天再来的时候发现居然mySQL又特么出幺蛾子，无法连接上了。 仔细看了一下错误原因：your password has expired.To log in you must change itusing a client that supports expired passwords。 大概意...
【SQL】Your password has expired. To log in you must change it.......
wzk4869的博客
07-17 2313
【SQL】Your password has expired. To log in you must change it.......
mysql（1862）密码过期详细解决办法
qq_40592811的博客
06-27 4014
今天同学使用mysql时，遇到一个关于mysql密码过期的问题，报错如下 1862:Your password has expired.To log in you must change it using a client that suports expired passwords. 现已解决，特在次记录下来，供以后自己查看使用，本次测试使用的是mysql5.7，以下的版本目前并没有遇到过密...
mysql密码到期 1862_mysql5.7密码过期ERROR 1862 (HY000): Your password has expired. To log in you must change...
weixin_36474795的博客
01-19 653
环境：ubuntu14.04 mysql5.7一、mysql5.7 密码过期问题报错：ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.翻译：错误1862(HY000):你的密码已经过期。登录必须改变它...
Your password has expired.To log in you must change it using a client that supports expired password
weixin_43356858的博客
05-26 1520
很久没有打开Navicat for MySQL，今天一打开，突然出现 Your password has expired.To log in you must change it using a client that supports expired password（密码过期） 这个错误，导致无法使用数据库，好在查了搜了很多资料和方法终于把这个问题解决了。看大佬的文章，感觉小白解决起来还是比...
Your password has expired. To log in you must change it using a client that supports expired passwor
学习印记 Learning imprint
03-07 1226
密码过期，需要重设密码，处理过程如下。mysql> use mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> set password = password('123456789'); Query OK, 0
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a …..
01-19
To log in you must change it using a client that supports expired passwords 出现问题原因： 可能是你在安装 MySQL过程中，通过mysqld –initialize 初始化 mysql 操作后，生成临时密码后，没有直接进行 MySQL...
MySQL错误代码1862 your password has expired的解决方法
09-09
主要为大家详细介绍了MySQL错误代码1862 your password has expired的解决方法，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
ORA-28001 the password has expired密码过期.docx
02-22
ORA-28001 the password has expired密码过期
Mysql 启动错误：Error while setting value ‘STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_
小洪帽i的博客
04-17 3713
Error while setting value 'STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION' to 'sql_mode'
LDAP Support
BLOG域名:programb.blog.csdn.net
04-22 524
RabbitMQ Features Get Started Support Community Docs Blog Overview RabbitMQ can use LDAP to perform authentication and authorisation by deferring to an external LDAP server. This functionality is pro...
mysql 报错 your password has expired.To log in you must change itusing a client that supports expired
weixin_46047612的博客
01-11 1508
mysql 报错 your password has expired.To log in you must change itusing a client that supports expired
Your password has expired. To log in you must change it using a client that supports expired passwords.
最新发布
09-03
- *1* [your password has expired.To log in you must change itusing a client that supports expired passwords](https://blog.csdn.net/fenniang16/article/details/81216602)[target="_blank" data-report-...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值