【mysql】You must reset your password using ALTER USER statement before executing this statement.
来源:互联网 发布:pdu协议数据单元 编辑:程序博客网 时间:2024/05/18 11:23
故障现场:登陆到MySQL服务器,不管你执行什么命令都报这个错
mysql> show databases;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> use test;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.......
怎么会这样呢?难道我进的是假服务器?
原因分析:这个主要是由一个参数控制的 default_password_lifetime,看看官方的解释
仔细看哈,Note信息有时候比上面的信息有用(英文的note我一般都是忽略的,有可能你忽略掉的那部分对性能也有帮助哦)
问题解决:在开源的世界里,我们不怕报错,有报错才有解决思路。下面来看下自己环境里的
mysql> select version();+--------------+| version() |+--------------+| 5.7.10-3-log |+--------------+1 row in set (0.01 sec)mysql> show variables like 'default_password_lifetime';+---------------------------+-------+| Variable_name | Value |+---------------------------+-------+| default_password_lifetime | 360 |+---------------------------+-------+1 row in set (0.00 sec)
alter user user() identified by "123456";
0 0
- 【mysql】You must reset your password using ALTER USER statement before executing this statement.
- MySQL错误:You must reset your password using ALTER USER statement before executing this statement.
- mysql error You must reset your password using ALTER USER statement before executing this statement.
- Mysql报错:You must reset your password using ALTER USER statement before executing this statement.
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- mysql5.7 You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this ..
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing t
- 【MySQL】ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- [mysql] ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- 错误mac mysql error You must reset your password using ALTER USER statement before executing this stat
- YOLOv2 论文笔记
- Linux下的PHP安全要点
- 网站的视频文件如何每次播放都从服务器下载而不是播放本地缓存
- Java8初体验(二)Stream语法详解
- Fire Game FZU
- 【mysql】You must reset your password using ALTER USER statement before executing this statement.
- linux各硬件运行状态查看
- ShareSdk分享到微信好友或者是微信朋友圈提示"由于invalid_app无法分享到微信"
- 网络基础知识、linux路由管理命令(route) 、ip命令、ifconfig命令的使用、linux网卡配置
- CSS清除浮动
- 基础总结知识点-第六章:主流动态网页技术
- 解读《德勤2017年全球CIO报告》:顶级CIO的炼成之道
- Django新手图文教程
- I/O流