mysql错误之------- mysql your password has expired
来源:互联网 发布:linux daemon用户权限 编辑:程序博客网 时间:2024/05/21 17:58
前几天在安装mysql用navicat这个客户端后发现密码需要重置,报的错误:mysql your password has expired。
于是咱们只需要:在DOC下面执行set password = password(‘新密码’);
即可Query Ok;
然后我后面了解了一下mysql密码过期的一些东西,
有如下总结:
从MySQL 5.7.4版开始,用户的密码过期时间这个特性得以改进,可以通过一个全局变量default_password_lifetime来设置密码过期的策略,此全局变量可以设置一个全局的自动密码过期策略。
用法示例:
可以在MySQL的配置文件中设置一个默认值,这会使得所有MySQL用户的密码过期时间都为90天,MySQL会从启动时开始计算时间。my.cnf配置如下:
如果要设置密码永不过期的全局策略,可以这样:(注意这是默认值,配置文件中可以不声明)
在MySQL运行时可以使用超级权限修改此配置:
还可以使用ALTER USER命令为每个具体的用户账户单独设置特定的值,它会自动覆盖密码过期的全局策略。要注意ALTER USER语句的INTERVAL的单位是“天”。
禁用密码过期:
让用户使用默认的密码过期全局策略:
从MySQL 5.7.6版开始,还可以使用ALTER USER语句修改用户的密码:
1 0
- mysql错误之------- mysql your password has expired
- mysql错误:your password has expired..
- mysql your password has expired
- mysql your password has expired
- MySQL错误号码1862:your password has expired
- MySQL错误号码1862:your password has expired
- MySQL错误号码1862:your password has expired
- MySQL错误号码1862:your password has expired
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MYSQL ERROR 1862 (HY000): Your password has expired.
- MYSQL ERROR 1862 (HY000): Your password has expired.
- Mysql 5.7 错误号码1862 Your password has expired. To log in you must change it using a client...
- 本文完全转载 MYSQL ERROR 1862 (HY000): Your password has expired.
- mysql密码过期的修改方法(your password has expired)
- mysql5.7初始化后连接mysql的时候报:Your password has expired.
- 【MySQL】MySQL 5.7 "Your password has expired.To log in you must change it using a client that suppor"
- Your password has expired的解决办法
- Memcache和redis的区别是什么?
- 为边框应用图片 border-image
- Ios的消息转发机制
- 用户界面框架jQuery EasyUI示例大全之菜单和拆分按钮演示
- IOS开发常用宏
- mysql错误之------- mysql your password has expired
- leetcode337. House Robber III
- 画笔使用(三)
- 【转】Spring 中jdbcTemplate 实现执行多条sql语句
- ps -aux ps -ef 命令
- 高并发电商平台架构实践
- spring计划任务,springMvc计划任务,Spring@Scheduled,spring定时任务
- Struts2中关于"There is no Action mapped for namespace / and action name"的总结
- java.lang.IllegalArgumentException: This method supports only the Types Cookie, CacheControl, Entity