mysql5.7 You must reset your password using ALTER USER statement before executing this statement.
来源:互联网 发布:手机淘宝解绑手机号码 编辑:程序博客网 时间:2024/05/16 12:43
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
参考自:https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
需要用ALTER USER重置一次密码才能执行sql语句,
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码
' PASSWORD EXPIRE NEVER;-- 密码永不过期
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码
' PASSWORD EXPIRE;-- 密码有过期时间
阅读全文
0 0
- 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.
- 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.
- 【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.
- 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
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this ..
- mysql5.7免安装版报错处理You must reset your password using ALTER USER statement before executing
- MySQL5.7 错误:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ...
- 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
- C++中类的静态数据成员函数解析
- 基于jquery的form表单验证
- Java生成图片验证码
- VPS和虚拟主机(虚拟空间)的区别
- 动态规划测试test20170520
- mysql5.7 You must reset your password using ALTER USER statement before executing this statement.
- 使用谷歌浏览器内核控件DCEF3拦截弹出的新页面到新标签页
- js 正则表达式
- Java中的自动装箱与拆箱(Autoboxing and unboxing)
- 【unity学习笔记】在unity中扩展编辑器添加菜单
- 什么是Pythonic?
- AssetBundle资源包------2
- ubuntu 16.04 LTS flash player播放器插件安装方法
- P1125 笨小猴