源码之家

  • 首页
  • 文章
  • 问答
  • 下载
您的位置: 首页  >  文章  >  ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

分类: 文章 • 2022-11-27 00:15:14

新安装的mysql 数据库 mysql -u root -p 登录进去之后,执行use sql;show databases;等指令提示错误
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st
使用
alter user ‘root’@‘localhost’ identified by ‘XXXX’;
更换密码,其中XXXX为自己要重设的密码,要字母大小写带特殊符号的密码,不然不会通过。
修改通过之后
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

相关推荐

  • 如何解决mysql创建表的时报错问题: You must reset your password using ALTER USER statement before executing this st
  • 【MAC mysql 5.7安装】报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement解决方法
  • ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st
  • mysql 密码过期(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
  • SQLException: An attempt by a client to checkout a Connection has timed out
  • DB2建库报错-SQL1052N 数据库路径不存在(Windows)
    网站免责声明 网站地图 最新文章 用户隐私 版权申明
本站所有数据收集于网络,如果侵犯到您的权益,请联系网站进行下架处理。   

Copyright © 2018-2021   Powered By 源码之家    备案号:   粤ICP备20058927号